Re: Difference execution plans for same query
It's a weakness of the MyISAM engine. Two possible remedies: switch to InnoDB, which doesn't depend on Analyze Table, or add Force Index clauses to the query.
BTW the query contains a serious inconsistency: select * ... group by sfol.item_id entails that all returned values for * except sfol.item_id will be arbitrary unless every one of those column values is unique per sfol.item_id. If that's the case, the Group By clause is superfluous.
Subject
Views
Written By
Posted
1951
February 25, 2016 12:05AM
Re: Difference execution plans for same query
1017
February 25, 2016 01:51AM
1042
February 25, 2016 03:51AM
1039
March 05, 2016 01:19AM
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.