Optimize Db2® indexes to improve performance and reduce costs
Index design is one of the most important aspects of Db2 application performance. Shoddy design can severely diminish reliability as well as increase CPU and storage costs. Yet, sophisticated design requires substantial DBA time and expertise.
DB/IQ Index Administrator helps DBAs design efficient indexes to maximize overall Db2 application performance and ROI. It recommends the best index candidates based on your current application SQL and system activity.
The Index Administrator consists of four phases:
Phases 3 and 4 are repeated continuously to achieve cost-effective and optimal index performance.
Software
DB/IQ
Quality Assurance for Db2 Applications