Navdeep,
what version are you on? Starting in 8i the cbo can use an index to
avoid a sort
(which might explain the better performance in your case), but
you wouldn't always see it in the explain plan. Have you tried tkprof
or 10046?

- ant


-----Original Message-----
From: Navdeep Sharma
[mailto:oracledba-ezmlmshield-x97124454.[Email address protected]
Sent: Friday, July 16, 2004 5:11 AM
To: LazyDBA Discussion
Subject: Index for Order by


Hi Team,

I was just wondering how the index being used for 'order by' clause. For
one of my table while accessing data & using Order By caluse in the
query, the response time improves when there's index for the column i am
using order by clause.
But why it's not showing that index usage in the expalin plan?

Any ideas??

Navdeep


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page