Database Tuning (MOSC)

MOSC Banner

invisible index and hints

edited Aug 30, 2010 10:15PM in Database Tuning (MOSC) 3 commentsAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center