Re: Why isn't an index being used here (nested query)
Interesting - and as suggested in the 2nd link, rewriting it as a join improved performance significantly even over my second version.
It still seems like it should be simple to pick an index for the primary query for this case. I wonder why is doesn't?
Thanks!
Subject
Written By
Posted
Re: Why isn't an index being used here (nested query)
October 06, 2009 06:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.