Menu Close
 
Data infrastructure optimization software
Data integration and quality software
Data availability and security software
Cloud solutions

Whitepaper

DB2 Index Optimization & Evolution

Indexing is the single most powerful tuning tool available to a DB2 Database Administrator (DBA). No other DB2 system tuning facility can deliver the kind of performance improvements possible via a good set of indexes.

This paper examines EZ-DB2’s automated index-design tools and describes the evolution of one tool in particular – XOP (indeX-OPtimizer). It also describes some of the theoretical concepts and implementation history leading to the current version of XOP.