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