Everything You Ever Wanted to Know About Db2 Indexes

Zoltan Toth, IBM

Download PDF

Indexes can significantly improve the performance of queries in a database.  Topics include the fundamentals of indexes in Db2, index compression technologies used by Db2, how to identify indexes suitable for compression, strategies for index maintenance, index monitoring, and Db2 enhancements designed to reduce the number of indexes required by exploiting indexes in novel ways.