Articles & Content

Archives

Squeeze the Most Out of your Indexes in DB2 9! (B12)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS



DATE: 2010-11-10 (14:15 - 15:15)
SPEAKERS: Jim Dee (BMC Software Inc.)

Index compression was announced as part of DB2 9 for z/OS, but it remains a mystery to many users. Is it the same as tablespace compression? If not, how is it different? How do I take advantage of it, and how can I know which indexes to compress? This presentation will cover some of the internals of index compression, and then it will answer your questions about when and how to most effectively use it.

EXP. LEVEL: Intermediate

OBJECTIVES:

Learn how index compression works.

Learn how index compression differs from tablespace compression.

Learn the steps necessary to implement compression for an index.

Learn how to identify the indexes which are the best candidates for compression.

Learn how to most effectively exploit index compression to save disk storage and meet your SQL performance goals.



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.