I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by IndexCol1
it always has Extra "Using FileSort", which means it is physically sorting
the result set.
I've tried different tables and sorted on different index columns, and it
is always using FileSort.
How do I get MySQL 4.1.0 to use an index when sorting a MyISAM table?
Or is Explain broken and does it always report it is using FileSort?
TIA
Mike

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.