always uses filesort even after adding indexes
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.
Subject
Views
Written By
Posted
always uses filesort even after adding indexes
2782
August 22, 2012 02:49AM
1287
August 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.