Query Tuning v11

This section describes the configuration parameters 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

Optimizer hints embedded in SQL commands are utilized when enable_hints is on. Optimizer hints are ignored when this parameter is off.

• On this page
• enable_hints