Re: Can't understand why optimizer doesn't work properly :(
Nothing wrong, it does need to scan all the rows in the outer query since the subquery is a dependant subquery and you do not have any where condition in the outer query.
How else do you expect this to be executed?
Draw the 2 tables on paper and see if you can find any better ways to do it manually by hand, if you cannot find a way, the server cannot either.
Subject
Views
Written By
Posted
3533
July 23, 2007 02:03PM
Re: Can't understand why optimizer doesn't work properly :(
2374
July 23, 2007 07:21PM
2451
July 24, 2007 12:26AM
2259
July 24, 2007 02:08AM
2498
July 24, 2007 02:42AM
2223
July 24, 2007 06:02PM
2327
July 25, 2007 11:10PM
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.