Marketing Cookie wrote!
Marketing Cookie wrote!
Syncsort - Resource Center
Contact Syncsort


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.

Get More Free Resources for You!