MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

Re: Index Search over 26 times slower than full table scan
Posted by: Andrew Morgan
Date: July 03, 2014 09:26AM

Have you tried running 
OPTIMIZE TABLE gig
to see if that gives the optimizer the index statistics is needs to make the smart choice?

Andrew Morgan.
@andrewmorgan
@clusterdb
http://www.clusterdb.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Index Search over 26 times slower than full table scan
2285
Christian Zintl
June 08, 2014 09:28AM
Re: Index Search over 26 times slower than full table scan
998
Andrew Morgan
July 03, 2014 09:26AM
Re: Index Search over 26 times slower than full table scan
1069
Christian Zintl
July 06, 2014 04:31AM


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.