Tuning queries like an optimizer developer

Date: 
Thursday, 12 April, 2018 - 11:45 - 12:45
Speaker: 
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.

 

sqladria

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

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023