Articles & Content

Archives

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

Topic: DB2 for z/OS

Subtopic: 2005



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



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.