Optimisation Service Centre and Optimisation Expert

Objectives:
Learn the basics of using DB2 Optimization Service Centre and Optimization Expert for z/OS and how they can solve common SQL Tuning problems.

Outline:
Introduction to Optimization Service Center (OSC) and Optimization Expert (OE)
Tuning workloads
Individual query analysis and tuning
Access plan graph
Query Annotation
The advisors – statistics, query and index
Visual Plan Hints

Full Abstract:
DB2 Optimization Service Centre and Optimization Expert for z/OS are SQL tuning tools with tightly integrated tuning advisors and advanced tuning tools to address both individual SQL statements and SQL workloads. Tuning advisors provide statistics, indexing, and query-rewrite recommendations, while advanced tuning tools like query annotation, access plan graph, query report, and visual plan hint facilitate deep SQL performance analyses when needed.