Help
Observation: Sort Invoked for Large Table
If you want to minimize the potential of DB2 sorting a large result set, add predicates to the WHERE clause. In addition, consider using an index on the GROUP BY, ORDER BY, or DISTINCT column in order to avoid the sort.