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

Hope this helps

Options: ReplyQuote

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