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 |