|
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
|
