
566 DB2 Performance Expert for Multiplatforms V2.2
Other skews
The group view feature of PE provides ways to look for skews on many more
performance indicators. As an example, Figure C-43 shows how to check for
skews on DB2 I/O data, such as rows read and rows selected.
Figure C-43 Checking skews on DB2 I/O data
In this example figure, two partitions deviate from the average rows read per
selected number. Partition 0 returns almost each row ...