Part I: Fundamental Concepts for Query Optimization
Chapter 1: Overview of Query Optimization
Chapter 2: Runtime Environment and Predicate Application
Chapter 3: I/O Behavior and Query Performance
Chapter 4: Doing it Sooner than Later
Part II: Understanding Access Path
Chapter 5: Access Methods
Chapter 6: Join Methods
Chapter 7: Sorting, Aggregation, and Duplicates Elimination
Chapter 8: Putting Them Together
Part III: Optimizer Statistics and Access Path Selection
Chapter 9: Overview of Optimizer Statistics
Chapter 10: Selectivity Estimation
Chapter 11: Cardinality Estimation
Chapter 12: Understanding Queries from Statistics Perspective
Part IV: Tuning Access Path with DB2 Optimization Service Center
Chapter 13: Methodology for Application Performance Tuning
Chapter 14: Methodology for SQL Performance Tuning
Chapter 15: Case Study
Part V: Performance topics
Chapter 16: Introduction to DB2 Instrumentation Facility Part 1
Chapter 17: Introduction to DB2 Instrumentation Facility Part 2
Chapter 18: Using OMPE for Performance Monitoring
Chapter 19: Using OSC for Application Performance Monitoring
Outcome: Upon Completion of this course, you will be able to: