DB2 for LUW

DATE: 2011-5-5 (01:30 PM - 02:30 PM)
SPEAKERS: Prashant Sogarwal (Suntrust Banks ), Mike Winer (IBM Toronto Lab)

In this session, you examine customer experiences with the recently introduced index compression feature in IBM DB2 9.7 for Linux, UNIX and Windows. You take a detailed, holistic look into index compression, including real-life examples of index compression and methods of getting the most from index compression. You learn about performance, I/O, index design, table design and lessons learned with compression. In addition, you see an overview of a compressed RID list, how encoding supports forward and reverse scans and prefix key compression. Plus you learn about the competitive advantage that index compression for DB2 9.7 has over other vendors.overview of compressed RID List, encoding to support forward & reverse scans, Prefix Key compression and competitive advantage over other vendors.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Overview of Index Compression technology

Lessons learned and ways to get most of index compression

Shows customer experience for a newly introduced technology

Competitive advantage of DB2 9.7 Index compression over other vendors.

Methods of getting the most from index compression