Single-query tuning features by product

Tuning features are available in Optim™ Query Tuner for DB2® for Linux®, UNIX®, and Windows®, Optim Query Tuner for DB2 for z/OS®, and Optim Query Workload Tuner for DB2 for z/OS. A subset of these features is available in Data Studio Integrated Development Environment and Data Studio stand-alone.

The following table shows the features that are enabled by the different products.

Table 1. Features by product
Feature Data Studio Integrated Development Environment and Data Studio stand-alone Optim Query Tuner for DB2 for Linux, UNIX, and Windows Optim Query Tuner for DB2 for z/OS Optim Query Workload Tuner for DB2 for z/OS
Access path Advisor   X X X
Access path reports     X X
Access plan graphs X X X X
Capture SQL statements from all sources X X X X
Index Advisor   X X X
Query Advisor   X X X
Query annotations   X X X
Query environment capture     X X
Query formatting X X X X
Statistics Advisor X X X X
Summary reports X X X X
Visual plan hints     X X
What-if analysis for indexes     X X

Feedback