Search notes:

Oracle: Init parameter OPTIMIZER_USE_INVISIBLE_INDEXES

The value of optimizer_use_invisible_indexes determines if the optimizer consideres indexes.

Index