Articles & Content

Archives

Vital Statistics - What You Should Know About DB2 for Linux, UNIX and Windows Catalog Statistics (G12)

Topic: DB2 for LUW

Subtopic: 2011



DATE: 2011-5-5 (02:45 PM - 03:45 PM)
SPEAKERS: John Hornibrook (IBM Canada )

The DB2 for Linux, UNIX and Windows query optimizer is responsible for choosing optimal query access plans, however it can't do its job properly without vital information about your data and database objects. The RUNSTATS utility has been used for years by database administrators to collect these statistics and store them in the system catalog tables. However, statistics collection has significantly evolved since RUNSTATS was first introduced. DB2 has a rich set of statistics to help the optimizer understand complex relationships in your data and across your tables. Statistics can be collected automatically and even at query optimization time. This presentation will provide an overview of DB2 statistics and the options to collect them, to help you achieve optimal query performance, with minimal administration effort.

EXP. LEVEL: Intermediate

OBJECTIVES:

Understand what types of statistics are available and how to decide when to collect them.

Learn how to capture complex relationships across columns, and even across tables, with statistical views.

Learn how to record statistics options in the system catalogs, to minimize statistics administration.

Understand how automatic and real-time statistics collection works.

Learn how to collect statistics using other utilities, such as LOAD, REDISTRIBUTE and index creation.



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.