Articles & Content


DB2 9 adds Advanced Statistics - Learn How to Use Them (E01)

Topic: 2007 NA

Subtopic: DB2 for LUW

DATE: 2007-5-7 (09:50 AM - 10:50 AM)
SPEAKERS: John Hornibrook (IBM Toronto Lab)

Database statistics are essential for enabling the query optimizer to choose good execution plans. DB2 for LUW contains a rich set of statistics representing the data characteristics of a single table. But often these statistics are insufficient to capture data characteristics across joins. DB2 9 adds a completely new concept called Statistical Views which are a powerful new form of statistic to capture cross schema relationships.They are particularly useful for correcting for skew and complex predicates. Be among the first to see this new technology and understand how to use it to improve performance of problem queries in your own environment.

EXP. LEVEL: Advanced


Discuss powerful new form of DB statistic

Provide skills in determining when and how to use statistical views

Deeper understanding of query optimization

Skills in interpreting QEPs via the Explain facility

Deeper understanding of how statistics affect query optimization

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.