Reporting capabilities in SQL PA

Db2 SQL Performance Analyzer (SQL PA) produces three expanding levels of detail in its performance report set, from the basic Cost Summary, to the Enhanced Explain and, finally, the Detail Trace report.

Each successive report is more detailed than its predecessor, including all the previous information, plus new forecast data for the SQL statements under study. There is also a fourth summary report, SQL PA Limits, which provides a quick eye-catcher for warnings and high costs. These topics examine the contents of each level of reporting, and explain the variables that they contain, and how to relate them to Db2®.