MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Large range query stops using indexes
Posted by: Joe Kuan
Date: February 28, 2009 04:49AM

It does. I have written a blog ages ago about how to optimize large query.
Basically, best to use force index to make sure range is used on the index

http://joekuan.wordpress.com/2009/01/23/mysql-optimize-your-query-to-be-more-scalable-part-12/

http://joekuan.wordpress.com/2009/01/23/mysql-optimize-your-query-to-be-more-scalable-part-22/

Hope this helps
Joe

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


Subject
Views
Written By
Posted
Large range query stops using indexes
7837
Solomon Chang
June 11, 2007 10:43PM
Re: Large range query stops using indexes
3575
KimSeong Loh
June 12, 2007 09:51PM
Re: Large range query stops using indexes
3635
Solomon Chang
June 20, 2007 11:06AM
Re: Large range query stops using indexes
3599
KimSeong Loh
June 21, 2007 03:20AM
Re: Large range query stops using indexes
3123
Joe Kuan
February 28, 2009 04:49AM


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.