Query tuning v16

These configuration parameters are used for optimizer hints.

enable_hints

Parameter type: Boolean

Default value: true

Range: {true | false}

Minimum scope of effect: Per session

When value changes take effect: Immediate

Required authorization to activate: Session user

Enables optimizer hints embedded in SQL commands. Optimizer hints are ignored when this parameter is off.