Re: Why are no indexes used in this case?
> the query shown is the same as the one before
False. If your 2nd query were the same, the first suggested revision would work with it.
> I don't know to rewrite the query
Again: replace IN( SELECT ...) calls with JOINs.
> why the primary key on ID is not used.
Again: JOINs generally use indexes more efficiently than IN(SELECT...).
Subject
Written By
Posted
February 03, 2013 06:38AM
February 03, 2013 10:27AM
February 03, 2013 11:27AM
February 03, 2013 01:16PM
February 03, 2013 03:35PM
Re: Why are no indexes used in this case?
February 03, 2013 04:04PM
February 03, 2013 03:59PM
February 04, 2013 03:01PM
February 04, 2013 09:11PM
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.