SQL Tuning Basics: Simple Steps to SQL Sufficiency

Wednesday, 15 junij, 2022 - 10:00 - 11:00
LUW Track
Damir Wilder

The purpose of this presentation is to give an overview of methods used in everyday SQL tuning of transactional databases, when an SQL query or a Batch job is underperforming and a quick solution is required. Describe generally available tools in DB2 that can assist in the daily SQL tuning and/or SQL performance problem detection. Describe how to find out what is happening right now in a database. Describe how to gather historical performance data for a database. Describe how to analyse locking issues. Describe how to identify the hottest tables and SQL queries in a database. Show several real-life scenarios of poorly performing SQL and what was done to improve it.



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 2022

VODICE -  13th - 16th June 2022