Overview
Review overall DB2 SQL Performance Considerations.
Experienced Data Processing personnel who have used SQL and need to explore Application Performance and Tuning issues.
At least six months experience using DB2 SQL.
2 days
Discuss the "behavior" of the DB2 Optimizer.
Explore DB2 SQL performance issues as revealed by using the EXPLAIN feature.
The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail. The results of the DB2 EXPLAIN process are reviewed to obtain insights into the
Way(s) that the Optimizer chooses the access path to access DB2 data.
Extensive workshops allow the students to test the performance "goodness" of several SQL statements.
The Plan Analyzer is used to review the results of the EXPLAIN process.
LEARNING OBJECTIVES
As a result of this class, the attendee will be able to -
Audience
Prerequisites
Course duration
Course outline
DAY 1
Workshop - The EXPLAIN statement and the PLAN_TABLE
WorkShop - More EXPLAIN exercises - Part 1
WorkShop - Re-Formatting SQL Statements
WorkShop - More EXPLAIN exercises - Part 2
DAY 2
WorkShop - EXPLAIN - the DSN_STATEMNT_TABLE and the PLAN_TABLE
WorkShop - Using Plan Analyzer to review the EXPLAIN results
Appendices
Appendix A - IBM Sample Tables
Appendix B - Bibliography
Appendix C - EXPLAIN PLAN Statement and PLAN_TABLE and DSN_STATEMNT_TABLE
Appendix D - Plan Analyzer