Tuning of SQL queries requires understanding why DB2 chose a particular access path and determining whether or not that access path should perform as expected. The key to this is understanding what filter factors are, how they are used by the Optimizer and how to get DB2 to better estimate them,
The second entry of this month’s theme, DB2 for z/OS performance, is a video by Thomas Baumann covering “Tuning Explained to C-level”. Take the time to watch this great video by one of IDUG’s Hall of Famers. Because, as important as tuning your system, is explaining what you did to your management.