Re: Strange behaviour with indexes and "order by"
Hi,
"with this structure and a request like this one, the order by clause seems not te be evaluated"
What do you mean by that? That the UPDATE was made in another order?
At any case, and regardless of your issue, the 'site_id' index is redundant and should be removed: it is covered by the multi-column 'page_order' index. So it's just a waste of resources.
Shlomi
Subject
Views
Written By
Posted
2404
August 14, 2008 01:33AM
Re: Strange behaviour with indexes and "order by"
1574
September 01, 2008 05:40AM
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.