invisible index and hints
The Oracle 11g Database New Features document http://download.oracle.com/docs/cd/B28359_01/server.111/b28279/chapter1.htm#FEATURENO07168 specifies that an invisible index is not used unless you specify the index with a hint. However, the Database Administrator's Guide http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/indexes003.htm#ADMIN12317 says the index is not used until you set the OPTIMIZER_USE_INVISIBLE_INDEXES parameter to TRUE.
In my testing I've not yet found a way to give a hint and get the index to be used. Is the new features guide wrong? Does someone have a demonstration of how to hint the optimizer to use the invisible index?
0