Smart and Continuous Optimization of Db2® Indexes
DB/IQ Index Administrator is a module of the DB/IQ suite dedicated to the automatic optimization of Db2® for z/OS indexes. It continuously analyzes workloads to detect overused, underused, redundant, or obsolete indexes, and provides recommendations based on actual usage.
Key Features
- Automatic identification of irrelevant indexes
- Recommendation and dynamic creation of optimal indexes
- Access analysis: see which programs and SQL statements access which objects/columns, and vice versa
- Suggestions for indexable column candidates
- Impact simulation: analyze and compare the effects of new indexes
- Custom scenario evaluation using user-defined weighting factors
- DB2 catalog cleanup: remove unused indexes with virtual index simulation
Key Benefits
- Improved performance through optimized indexing
- Cost reduction by eliminating unnecessary indexes
- Time savings via automated recommendations and simulations
- Greater visibility into real SQL data usage
- Informed decision-making through impact simulations
- Business alignment with customizable evaluation criteria
- Reduced maintenance and enhanced long-term stability
