15 Aug
Invisible indexes in 11G
11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.
We can create an index as invisible or we can alter an index to become invisible.
YAS@11G>drop table t;