MySQL Forums :: Optimizer & Parser :: simple uses of order by datetime keep causing 'using filesort'


Advanced Search

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' 1716 park albert 08/19/2014 05:44PM
Re: simple uses of order by datetime keep causing 'using filesort' 873 Rick James 08/20/2014 07:34PM


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.