MySQL Forums :: Optimizer & Parser :: always uses filesort even after adding indexes


Advanced Search

always uses filesort even after adding indexes
Posted by: Pranav Gore ()
Date: August 22, 2012 02:49AM

Created a table with a interger column as index and then fired following query :

EXPLAIN SELECT score FROM score_history ORDER BY score;

this shows "using index" under the section "extra" in output.

But when i fire :

EXPLAIN SELECT * FROM score_history ORDER BY score;

this shows "using filesort" under the section "extra" in output.

Options: ReplyQuote


Subject Views Written By Posted
always uses filesort even after adding indexes 1891 Pranav Gore 08/22/2012 02:49AM
Re: always uses filesort even after adding indexes 947 Rick James 08/22/2012 10:52PM


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.