From: Date: October 15 2003 11:20am Subject: Re: Select always "Using FileSort" List-Archive: http://lists.mysql.com/mysql/151645 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Whenever you use select * MySQL will skip using index. For more information, http://www.mysql.com/doc/en/MySQL_indexes.html . Thanks, Ram >>> mos 10/15/2003 10:17:22 AM >>> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=pram@stripped