This metric shows the average sort time duration as computed by (TOTAL_SORT_TIME / TOTAL_SORTS).
Average Sort Time can be improved by reducing the number (and percentage) of Sort Overflows, by making sorts smaller, and by reducing the total number of sorts in the database.
To improve average sort times, analyze the SQL workload to find statements with the highest aggregate Sort and CPU costs, then implement Clustering indexes, MDC tables, or MQTs to abate the sort costs. For best results in the least amount of time, DBI suggests using pureFeat for DB2 LUW.