Re: Can't understand why optimizer doesn't work properly :(
It is not possible to execute the subquery first when it does not know the value of Messages.Ask
Only after you execute the outer query, you can obtain the value of Messages.Ask, then substitute it into the subquery to be executed, the subquery needs to be executed once for every row of the outer query.
Write out 2 tables with a few rows and try to execute this manually and see if you can do it or not. If not, the server cannot either.
Subject
Views
Written By
Posted
3276
July 23, 2007 02:03PM
2244
July 23, 2007 07:21PM
2325
July 24, 2007 12:26AM
2139
July 24, 2007 02:08AM
2352
July 24, 2007 02:42AM
Re: Can't understand why optimizer doesn't work properly :(
2085
July 24, 2007 06:02PM
2201
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.