Articles & Content

Archives

Rev up your SQL Applications with Enhanced Statistics! (B04)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS



DATE: 2010-11-9 (08:30 - 09:30)
SPEAKERS: Jim Dee (BMC Software Inc.)

You may have heard that Enhanced Statistics were added to DB2 for z/OS with DB2 9, and you probably wondered what they are and how they can help. This presentation will answer your questions about what the statistics are, how they are enabled, how they get collected, and what effect they will have on your SQL execution.

EXP. LEVEL: Advanced

OBJECTIVES:

What statistics are affected by the STATCLUS DSNZPARM parameter in DB2 9?

What improvements have been made to the calculation of cluster ratio?

What does Data Repeat Factor mean and how is it calculated?

When are the enhanced statistics used by the DB2 optimizer?

What can you do to exploit these statistics to improve the performance of your SQL applications?



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.