SQL Performance Basics: Part 5, Avoid Sorting

(Craig S. Mullins) Sorting is a very costly operation that you should strive to avoid if at all possible. Indexes are very useful for this purpose. DB2 can choose to use an available index to satisfy the sorting requirements of an ORDER BY, GROUP BY, or DISTINCT clause.

Read More - Register for Free Membership