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 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - (TBA) September 2018
Opatija - 29th & 30th November 2018