Re: Simple Query takes 50 seconds with Indexing
The diff seems to lie in whether the engine needs to hit the data file for values.
1. Consider ...
- changing covering indexes to using short left substrings of varchar fields
- adding covering indexes for frequent queries
2. How much RAM is available to MySQL?
PB
Subject
Views
Written By
Posted
2129
July 21, 2011 08:26AM
Re: Simple Query takes 50 seconds with Indexing
1225
July 21, 2011 11:34AM
878
July 21, 2011 10:04PM
873
July 22, 2011 11:01PM
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.