Lies, Damned Lies and Statistics

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.