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
4235
September 20, 2010 06:28AM
1694
September 23, 2010 09:29AM
1744
September 24, 2010 04:32AM
1676
September 24, 2010 10:24PM
1696
September 27, 2010 08:56AM
Re: Big problems on optimizing query
1560
September 28, 2010 05:18PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.