Before 11g, Oracle didn’t have the facility to make an Index Invisible or
visible……
Invisible Indexes, as the name imply is invisible to the optimizer except when we explicitly
make it visible. When an index is made invisible it remains unavailable
for the optimizer while running execution plans for queries. While running execution plans the optimizer decides which indexes to be
used for faster execution.