Re: Big problems on optimizing query
Posted by:
Rick James
Date: September 28, 2010 05:18PM
Your second posting -- there were no useful indexes!
-> and d.date = '2010-07-08'
-> and cc.costcenter = 21600
-> and an.approvalNumber = 211517279
If any one of those fields had been indexed, the query would have run much faster. If all three were indexed, MySQL (MyISAM or InnoDB) would have picked the 'best' of them.
Subject
Views
Written By
Posted
4030
September 20, 2010 06:28AM
1604
September 23, 2010 09:29AM
1653
September 24, 2010 04:32AM
1552
September 24, 2010 10:24PM
1613
September 27, 2010 08:56AM
Re: Big problems on optimizing query
1457
September 28, 2010 05:18PM
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.