Articles & Content
Topic: 2007 EU
Subtopic: DB2 for LUW
DATE: 2007-11-7 (17:30 - 18:30)
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 statisticto capture cross schema relationships.They are particularly useful for correcting for skew and complex predicates. Attend this presentation 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. Helps the query optimizer choose better Query Execution Plans (QEPs)Solves many of the costing limitations with current statistics
Provide skills in determining when and how to use statistical views
Deeper understanding of query optimization
Skills in interpreting QEPs via the Explain facility
Learn more about the new Explain Diagnostic facility
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.