Articles & Content

Archives

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

Topic: DB2 for LUW

Subtopic: 2007



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

OBJECTIVES:

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



Click Here to Download

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