OPTIMIZER_USE_INVISIBLE_INDEXES

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.