Re: Oracle 11g - Invisible Indexes

Hi Robert

> Now that I can't force the use of an invisible index
> with a hint, what good is the feature?

The aim of the feature is twofold:

- Testing a DROP INDEX without really dropping it. IMHO this is only
interesting for very large indexes. Otherwise it isn't a problem
recreating it...

- Testing a CREATE INDEX without impacting every operation on the
database. To enable it the initialization parameter
optimizer_use_invisible_indexes may be set at session level.

Note that if hints would be honored the feature would be useless for the
former utilization.


Best regards,
Chris
--
http://www.freelists.org/webpage/oracle-l

Other related posts: