OPTIMIZER_USE_INVISIBLE_INDEXES

OPTIMIZER_USE_INVISIBLE_INDEXES enables or disables the use of invisible indexes.

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

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.