Re: Issues with Sub-selects and performance on Win 2003
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.
Subject
Views
Written By
Posted
3770
November 05, 2004 07:01AM
2471
November 06, 2004 03:23PM
2409
November 11, 2004 09:05AM
Re: Issues with Sub-selects and performance on Win 2003
2458
November 11, 2004 07:11PM
2421
November 12, 2004 05:49AM
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.