Menu Close
 
Data infrastructure optimization, availability & security software
Data integration & quality software
The Next Wave of technology & innovation

White Paper

Db2 Index Optimization & Evolution

How Elevate DB2 can help with Db2 Index Optimization

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 Elevate 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.