OPTIMIZER_IGNORE_HINTS
OPTIMIZER_IGNORE_HINTS enables embedded hints to be ignored.
| Property | Description |
|---|---|
| Parameter type | Boolean |
| Default value | FALSE |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Modifiable in a PDB | Yes |
| Range of values | true | false |
| Basic | No |
| Oracle RAC | Different values can be set on different instances. |
When this parameter is set to TRUE, the optimizer ignores embedded hints.
The default value is FALSE. When this parameter’s value is FALSE, the optimizer does not ignore embedded hints.