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
3656
July 23, 2007 02:03PM
Re: Can't understand why optimizer doesn't work properly :(
2415
July 23, 2007 07:21PM
2490
July 24, 2007 12:26AM
2296
July 24, 2007 02:08AM
2538
July 24, 2007 02:42AM
2253
July 24, 2007 06:02PM
2374
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.