Interpreting the Explain tables, using optimiser hints and establishing query stability

Date: 
Monday, 8 December, 2014 - 16:00 - 17:00
Speaker: 
Gareth Z Jones

Interpreting the Explain tables, using optimiser hints and establishing query stability: There presentation delves into the information available in the EXPLAIN tables which can be used to understand what access path is chosen by DB2 and why. It also looks at how this same infrastructure can be used to provide hints to the optimiser to influence access path selection, and ultimately to ensure that preferred access paths are used for critical queries. 

 

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