MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizer ignores number of records
Posted by: Ravenous Bugblatter Beast
Date: October 21, 2006 05:05AM

Try grouping by the item number instead of its description - I think having a group by field that is not part of your index may be causing the dreaded "using temporary;using filesort" which is what is making the query slow.

If you want to force the table to join in a certain order look at STRAIGHT_JOIN in the manual, but I think it is file temporary table/filesort that is hurting your performance.

Options: ReplyQuote


Subject
Views
Written By
Posted
2744
September 15, 2006 06:28AM
Re: Optimizer ignores number of records
1907
October 21, 2006 05:05AM


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.