MySQL Forums
Forum List  »  Optimizer & Parser

Re: Please help me optimize this query
Posted by: Rick James
Date: August 31, 2008 11:40PM

Only a small percentage of rows are about Jumper, right? It has to wade thru lots of rows to find the 60 you want.

Consider FULLTEXT index type.

You have a GROUP BY, but no aggregrate expressions. This is probably a mistake.

Options: ReplyQuote


Subject
Views
Written By
Posted
3112
July 28, 2008 05:23PM
Re: Please help me optimize this query
2033
August 31, 2008 11:40PM


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.