Index not used for order by when more than 1 field selected, nowhere clause

Hi, I'm having a hard time figuring why mySQL does not use the index when sorting a table without any where clause when I include more than 1 field in the select part. To resume the case, I created a temp table with 3 single fields, added an index (see bottom for more details), ran 2 queries

Re: Index not used for order by when more than 1 field selected, no where clause

15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]: Hi, I think you are mis-understanding the information provided. What the "using index" note means is that the isbn column is part of the index, and since that is all that is selected, the index file is used to provide the data, the data