Db2 optimization profiles – tell the optimizer what to do

Date: 
Tuesday, 28 May, 2019 - 10:15 - 11:30
Program: 
LUW Track
Speaker: 
Marcin Marczewski

Db2 comes with a smart query optimizer which tries to execute every query with best access plan. How to tell the optimizer what to do? Which join method to use or at which optimization class run your queries for a specific session? During this presentation we will discuss how optimization profiles can be created and maintained. Optimization guidelines with examples will also be covered.

 

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