MySQL Forums
Forum List  »  Optimizer & Parser

Re: slow subquery
Posted by: Brian Moon
Date: December 07, 2005 08:18AM

Without seeing the query in question it is hard to say. It could be that indexes could be added to the tables that could help the performance of the query in question. You might have a look at the EXPLAIN syntax in the docs for more info on optimizing a table/query.

Brian Moon
Phorum Dev Team
http://phorum.org/
-----------------------
dealnews.com - How to go broke saving money.
http://dealnews.com/

Options: ReplyQuote


Subject
Views
Written By
Posted
6641
December 01, 2005 03:33AM
Re: slow subquery
2912
December 07, 2005 08:18AM
2727
December 09, 2005 02:32PM
2668
December 19, 2005 11:58PM
3167
December 30, 2005 12:43PM
3409
December 30, 2005 02:25PM
2628
February 22, 2006 01:06PM
5225
February 23, 2006 08:04AM


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.