Tips for sort sequence

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 Link to Information center.