Steroids for the Optimizer – An Introduction to (Advanced) Statistics

Date: 
Friday, 27 November, 2020 - 10:30 - 11:30
Program: 
LUW Track
Speaker: 
Matthias Nicola

Db2 uses a cost-based query optimizer that is vitally dependent on appropriate statistics to generate efficient execution plans. However, it is often not obvious when to use which of the many options for the RUNSTATS command to collect the "right" kind of statistics. This session presents a set of practical examples to explain how different types of statistics affect query optimization. We also discuss RUNSTATS measurements to illustrate the overhead of collecting more advanced statistics. As a result you will be able to determine when it is worthwhile to use more advanced concepts such as distribution statistics, column group statistics, or statistical views. Provide the right steroids to the optimizer to boost performance!

 

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 2020

VIRTUAL EVENT - 25th - 27th November 2020