Db2 12 Function Levels 501-510 - What You Need to Know

Date: 
Wednesday, 15 June, 2022 - 11:30 - 12:30
Program: 
z/OS Track
Speaker: 
Emil Kotrč

An access path selected by Db2 drastically affects how well or how badly your SQL statement and overall application perform. Developers should be familiar with what the access path is and how to read it, while database administrators need to be able to maintain workload stability avoiding performance degradations and resource consumption spikes. This session will talk about how to interpret an access path with EXPLAINs, discuss how to influence the optimizer, and cover the ways to maintain and manage access paths for both static and dynamic SQL statements

 

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