MySQL Forums
Forum List  »  Optimizer & Parser

Re: Issues with Sub-selects and performance on Win 2003
Posted by: KimSeong Loh
Date: November 11, 2004 07:11PM

Maybe rewriting your subqueyr with JOIN could help speed up your query, subquery is pretty new in MySQL and the optimisation may not be very good yet.

http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html

You should do an EXPLAIN to see how MySQL plan to execute your query and decide what you can do.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Issues with Sub-selects and performance on Win 2003
2380
November 11, 2004 07:11PM


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.