Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | Boolean |
Default value | false |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Range of values | true | false |
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.