This class is designed to break down SQL statements in detail so the students understand in depth what the DB2 optimizer goes through in fulfilling an SQL request. Time will especially be spent breaking down SQL Joins and Subqueries in order to understand the fundamental issues associated with performance.

The class will address performance-related issues in relationship to database design, indexing, efficient and effective SQL queries, and the gathering of accurate statistical information for optimization. Students will come out of this class having a much better understanding of why certain optimizations are chosen, and what can be done to get DB2 to choose differently.

Much of the class will be in workshops where the students will write queries, execute DB2 Explains, and perform analysis on the information. Many of the workshops have the students rewrite and/or apply tuning statements to existing queries in order to get them to perform more efficiently.

Students will know exactly what steps to take in getting poor performing SQL queries to execute more efficiently.

This class is designed for application developers, DBAs, and anyone with some SQL knowledge that has an interest in DB2 performance related issues.

• Inner and Outer Joins
• Subqueries
• Basic Tuning Tools
• Predicate Types and Performance
• Basic Access Paths and Performance
• Multi Table Access Paths
• The DB2 Catalog and Access Paths
• Advanced Query Tuning

A working knowledge of SQL.