MySQL Forums
Forum List  »  Optimizer & Parser

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
2670
August 22, 2012 02: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.