MySQL Forums
Forum List  »  Optimizer & Parser

simple uses of order by datetime keep causing 'using filesort'
Posted by: park albert
Date: August 19, 2014 05:44PM

Hello,
I have a simple table, InnoDB,

idx => primary key, auto-increment,
name, ....

start_datetime => index

and i tried a simple query like,

"explain select * from start_datetime_info order by start_datetime"
i tried it with test data consisting of more than 100,000 rows.
it always shows 'using filesort'.

i thought it would be very simple. i indexed 'start_datetime' column and tried 'order by start_datetime'

what kind of mistakes could i make on this..

Options: ReplyQuote


Subject
Views
Written By
Posted
simple uses of order by datetime keep causing 'using filesort'
2831
August 19, 2014 05:44PM


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.