MySQL Forums
Forum List  »  Performance

Re: Using 'Order By' disables use of index
Posted by: Tomas Prochazka
Date: December 10, 2007 06:11AM

I tested this on my app and for most of sql queries is 14x faster use FORCE INDEX() instead of filesort. Only for few queries is filesort radically faster.

Why MySQL query optimizer doesn't handle this? Or it's impossible to create some heuristic to decide whether to use the filesort method or index?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using 'Order By' disables use of index
1990
December 10, 2007 06:11AM


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.