Re: Optimizer ignores number of records
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.
Subject
Views
Written By
Posted
2862
September 15, 2006 06:28AM
Re: Optimizer ignores number of records
1976
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.