DB2 Total Sorts – overflows – improve performance

(Jack Vamvas) Sorts are part of processing queries , but excessive sorts , especially in an OLTP databases can kill performance. Sorts hit IO,CPU and lead to slow response time. A typical DB2 Sort occurs if a sql statement uses an ORDER BY but can’t find a relevant index.

Read More - Register for Free Membership