SQL Performance (MOSC)

MOSC Banner

New AP rejected (non-guess): favored index only range scan

edited Mar 12, 2014 1:37PM in SQL Performance (MOSC) 20 commentsAnswered

Has anyone ever run across this message in a 10053 trace output?  The access path that was rejected was the one with the lowest cost.  If I force its use by using an index hint, the performance is drastically better.  Why is the optimizer rejecting the index?

I am on 11.1.0.7.  I tried using all rows and first rows optimizer goal with no change in behavior.  The only way I am able to influence the optimizer to use the index (other than the index hint) is by changing the optimizer_index_cost_adj parameter.  I did a Google search and this Russian article is the only result I found:

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