EZ-XOP Index Optimizer uses patented technology to optimize your DB2 indexes for DB2 running on IBM S/390, z/OS and compatible operating environments. Implementation of XOP recommended indexes will provide a dramatic improvement in your system performance and resource utilization.

EZ-XOP Index Optimizer is workload-centric - That is, it arrives at the optimal index configuration that will benefit the workload as a whole, rather than focussing on specific SQL statements. This is impossible to achieve using manual techniques.

"It's not whether you can afford EZ-XOP, its whether you can afford NOT having it"
- IT manager, Major Credit Card Company.

EZ-XOP Index Optimizer Uses the DB2 Optimizer -EZ-XOP Index Optimizer is NOT a modelling tool; It does not try to “second-guess” the DB2 Optimizer. Rather, it actually harnesses the power of the DB2 Optimizer to determine the optimal indexes. Patented algorithms and evolutionary techniques are used to establish and evaluate possible index combinations. EZ-XOP Interacts with the DB2 optimizer to re-cost the SQL in the workload with different index combinations and, through a complex sequence of iterations, the optimal set of indexes for the entire workload is evolved.

Because EZ-XOP actually utilizes the DB2 Optimizer to determine the optimal indexes, it means that you will automatically exploit new optimizer indexing enhancements if you re-optimize each time you install a new DB2 release.

"EZ-XOP is the only scientific way to determine the optimum index configuration for your DB2 workload" - Software developer, Major Services company.

EZ-XOP Index Optimizer Reporting provides powerful facilities allowing the DBA to easily compare the original and recommended index configurations and respective costs. The DBA can view the original and new access paths for each statement and related indexes. He can easily identify on a Workload basis, which Index recommendations will give the greatest cost saving.

EZ-XOP Index Optimizer “What-If” Analysis - Index Optimizer provides a powerful facility allowing the DBA to experiment with different combinations of the recommended indexes. The DBA can now easily CREATE and DROP different combinations of Indexes and immediately see the impact on the whole workload.

Some sampleEZ-XOP Index Optimizer Reports.....

Predicted Savings Summary displays the Original Cost, Predicted Cost and %Saving for each analyzed table in the Workload:

SQL Predicted Cost Savings shows for each Statement, the frequency, total original cost, total predicted cost and % Savings:

Index recommendations shows the new XOP recommended indexes for each table and any user defined indexes that were not selected:

Predicted Index Utilization shows for each SQL statement in the Workload the Original indexes used compared with the indexes used in the optimized configuration:

SQL Explain data shows for a particular SQL statement the original and predicted access path and corresponding indexes:

Refine Indexes and Recalculate allows the DBA to play powerful “what-if” cost comparisons of different index configurations:

These are just samples of the various reports that are available. This is the XOP Report Menu, you showing all the report types that are available:

Developed by

for TACT software