1.223 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.