Articles & Content

Archives

New and Improved Statistics in DB2 for z/OS V8 (B10)

Topic: 2005 EU

Subtopic: DB2 for z/OS



DATE: 2005-10-25 (14:45 - 15:45)
SPEAKERS: Jim Ruddy (IBM Silicon Valley Lab)

This presentation will describe new and improved statistics for data and indexes, extensions to support DPSIs, and non-uniform statistics for non-indexed and indexed columns. There is also a tutorial reminder on optimizer filter factor calculations based on these statistics set in the guise of an improbable reality show.

EXP. LEVEL: Beginner

OBJECTIVES:

New data and index statistics

Statistics for Data Partitioned Secondary Indexes

Statistics of padded and non-padded indexes

Non-uniform statistcs and why they are important

How statistics are used to compute filter factors



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.