MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Simplify optimization with distinct names
Posted by: Rick James
Date: August 20, 2009 09:05PM

Sorry, MySQL is not very good at optimizing subqueries.

You might be able to greatly speed up some of the MAX stuff by the trick described here:

http://forums.mysql.com/read.php?10,236805 (Complex Select with Min/Max Syntax)
http://forums.mysql.com/read.php?52,272271 (Subquery and JOIN's)
http://forums.mysql.com/read.php?10,266585 (How does group by algorithm works?)
http://forums.mysql.com/read.php?10,250033 (Listing threads by newest posts?)

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


Subject
Views
Written By
Posted
Simplify optimization with distinct names
3380
Chris Hennick
August 19, 2009 11:10AM
Re: Simplify optimization with distinct names
2171
Rick James
August 20, 2009 09:05PM


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.