Articles & Content

Archives

Advanced Statistics for Faster BI Queries - Learn How to Use Them (D13)

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

OBJECTIVES:

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!

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.