MySQL Forums
Forum List  »  Optimizer & Parser

Re: How to optimize an ORDER BY query using a range to avoid any filesorts
Posted by: Faury Rodriguez
Date: October 14, 2007 11:21PM

Thank you for the reply.

Is there any way of sorting a list of results given a range of values in the where condition without using filesort, which takes a while when sorting through 1 million+ records?

Options: ReplyQuote




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.