Tuning queries like an optimizer developer

Thursday, 12 April, 2018 - 11:45 - 12:45
Patrick Bossman

This presentation is a deep dive into analyzing query performance situations. The best practices approach utilized by Db2 for z/OS query performance diagnosis team. This presentation walks through what information is used, how information is layered onto the query, explain information, and optimizer choices information - and how to use it to evaluate a chosen access path versus alternates. While this presentation is targeted to Db2 for z/OS, the principles apply to evaluating query performance for any relational database.



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 2019

Ljubljana - 9th & 10th April 2019
Belgrade - 12th April 2019
Šibenik - 26th - 30th May 2019
Zagreb - 26th September 2019
Opatija - 28th & 29th November 2019