Re: Indexing: on WHERE columns or ORDER BY columns?
I missed the equal comparison on col1 and col2, adding the index (col1,col2,col3) does removes the sorting, works only if both col1 and col2 are equal comparison.
Subject
Views
Written By
Posted
2420
May 31, 2005 04:58AM
1585
May 31, 2005 07:23PM
1560
June 01, 2005 12:29PM
Re: Indexing: on WHERE columns or ORDER BY columns?
1443
June 02, 2005 06:44PM
1552
June 01, 2005 11:41AM
1526
June 03, 2005 05:21PM
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.