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