Articles & Content
Topic: 2006 EU
Subtopic: DB2 for LUW
DATE: 2006-10-3 (15:15 - 16:15)
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.