Re: Oracle 11g - Invisible Indexes
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- Date: Tue, 21 Aug 2007 10:28:03 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
