DB2 for LUW

Customer Experiences with Index Compression for IBM DB2 9.7 (C11) 

May 05, 2011 03:00 PM

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


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

pdf file
NA11C11.pdf   7.68 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.