Lies, Damned Lies and Statistics

Date: 
Monday, 15 junij, 2009 - 14:15 - 15:15
Speaker: 
Andy Ward

Objectives:
To give an overview of the importance of collecting and providing DB2 with good statistics and ensuring filtering takes place as early as possible. The session also looks to introduce some of the new statistics related features available in DB2 9 as well as highlighting the problem of column correlation and providing steps to both detect and fix it.

Outline:
The DB2 Catalog
A brief History
Real Time Statistics
Distribution Statistics
Including Histogram Statistics
Defining, detecting and fixing column correlation
A look at the importance of good filtering

Full Abstract:
We spin a lot of cycles collecting them, how can we get the best out of them? A look back at how the catalog has grown in recent releases and what DB29 brings us in this area. We will also take a look at column correlation, what it is, how to detect it and how to fix it. Real Time Statistics, filtering and the importance of Distribution Statistics are also 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