SQL Tuning Basics: Simple Steps to SQL Sufficiency

Date: 
Wednesday, 15 lipanj, 2022 - 10:00 - 11:00
Program: 
LUW Track
Speaker: 
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.

 

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