Optimisation Service Centre and Optimisation Expert

Tuesday, 24 June, 2008 - 11:15 - 12:15
Mike Bracey

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

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.



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020