The following table shows the features that are enabled by the different products.
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 |