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

Oracle LazyDBA home page