MySQL Forums
Forum List  »  Optimizer & Parser

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Large range query stops using indexes
3050
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.