MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Can't understand why optimizer doesn't work properly :(
Posted by: KimSeong Loh
Date: July 24, 2007 02:08AM

Does that documentation page mentioned that it will execute the subquery first?

From the EXPLAIN in the page, the subquery is executed after the outer query.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Can't understand why optimizer doesn't work properly :(
3542
Sergey Belov
July 23, 2007 02:03PM
Re: Can't understand why optimizer doesn't work properly :(
2376
KimSeong Loh
July 23, 2007 07:21PM
Re: Can't understand why optimizer doesn't work properly :(
2454
Sergey Belov
July 24, 2007 12:26AM
Re: Can't understand why optimizer doesn't work properly :(
2259
KimSeong Loh
July 24, 2007 02:08AM
Re: Can't understand why optimizer doesn't work properly :(
2499
Sergey Belov
July 24, 2007 02:42AM
Re: Can't understand why optimizer doesn't work properly :(
2223
KimSeong Loh
July 24, 2007 06:02PM
Re: Can't understand why optimizer doesn't work properly :(
2331
Sergey Belov
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.