MySQL Forums
Forum List  »  Performance

Re: Indexing ORDER BY Columns
Posted by: Haafiz Dossa
Date: December 27, 2004 03:38PM

I figured out the problem... It turns out that on the set of data I was testing, it was already ordered by the order column when the data was inserted, so mysql was smart enough to realise that and not bother with the index. On antoher test set it wasnt pre-ordered so it ended up using the index.

Options: ReplyQuote


Subject
Views
Written By
Posted
2556
December 20, 2004 08:28PM
1868
December 21, 2004 11:36AM
Re: Indexing ORDER BY Columns
1814
December 27, 2004 03:38PM


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.