Re: Indexing ORDER BY Columns
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.
Subject
Views
Written By
Posted
2744
December 20, 2004 08:28PM
1961
December 21, 2004 11:36AM
Re: Indexing ORDER BY Columns
1911
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.