Property | Description |
---|---|
Parameter type |
Boolean |
Default value |
|
Modifiable |
|
Range of values |
|
Basic |
No |
OPTIMIZER_USE_INVISIBLE_INDEXES
enables or disables the use of invisible indexes.
Values
true
Invisible indexes are treated as visible (normal) indexes.
false
Invisible indexes will not be considered by the optimizer but will still be maintained by DML operations.