MySQL Forums
Forum List  »  Optimizer & Parser

Re: i've got the query optimization blues ... stumped
Posted by: Toa Sty
Date: January 04, 2007 10:32AM

That's a lot to take in in one go. Have you tried starting with a really simple version of it and adding complexity slowly to see at what point things start going slowly? I'd probably take a look at just the subselect first.

So if you like, try posting the explain plans here in [ code ] tags for your query and just the subselect, and someone should be able to help.

(MySQL not using indexes when you think it should can be a result of analyze table not having been run for a while so you might want to try that before you start changing the query)

-----------------------------------------
email: 'toasty'*3 at gmail

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: i've got the query optimization blues ... stumped
2083
January 04, 2007 10:32AM


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.