Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Difference in speed of sorting using index and non-index column in the order by
Dear list,
Someone ask me when Oracle is doing a
sort, will it make a difference if we use indexed column and non-indexes column
in the order by clause, my initial thinking was index only speed up the
retrieval of data from disk, Oracle probably using other algorithm in
sorting records, so indexing is not relevant in that case. Can someone shed
light on this question.
KC
Received on Tue Jun 05 2001 - 08:56:36 CDT