MySQL Forums
Forum List  »  Performance

Re: Attempt to split big table into smaller one made query slower
Posted by: Patrick St.Onge
Date: March 24, 2010 02:26PM

so how easy is it to optimize the group by part query? I removed parts of the query to see what was making it slow. It turns out that the group by is the cause. Without it (and any other part of the query that requires it), it runs much faster. I tried adding an index to position, keyword but it made no difference with the original query. So is it possible to have a group by use the index?



Edited 1 time(s). Last edit at 03/24/2010 02:17PM by Patrick St.Onge.

Options: ReplyQuote




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.