Re: Order by using filesort on where
Hi Rick,
I have tried your solution and it work. Can I ask more favor, maybe you could tell what really happens here and why do I have to use the compound index. How the compound index works. So i could understand more about on indexes.
thanks
Best Regards,
maye
Subject
Written By
Posted
Re: Order by using filesort on where
March 19, 2009 01:25AM
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.