You can avoid some sorts if index keys are in the order needed by ORDER BY, GROUP BY, a join operation, or DISTINCT in a column function. In other cases, such as when using list sequential pre-fetch, the index does not provide useful ordering, and the selected data might need to be sorted.
For more information, see Database Performance and Query Optimization in the
Information Center .