Re: Using 'Order By' disables use of index
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?
Subject
Views
Written By
Posted
11333
January 07, 2005 04:17PM
5083
January 08, 2005 11:38AM
3089
January 10, 2005 08:09AM
2512
January 10, 2005 06:47PM
1918
January 11, 2005 09:58AM
2025
January 11, 2005 07:37PM
Re: Using 'Order By' disables use of index
1990
December 10, 2007 06:11AM
1829
March 29, 2005 07:53AM
1744
January 13, 2005 02:17PM
1904
March 29, 2005 07:45AM
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.