IBM® Optim™ Query Tuner for DB2® for z/OS® provides
advanced query tuning capabilities for individual SQL statements that run
on DB2 for z/OS data
servers.
When the license for IBM Optim Query Tuner for DB2 for z/OS is
activated on a data server, the following activities are enabled in
the query tuner client:
- Viewing formatted SQL statements with statistical annotations
- Getting expert advice in the following areas:
- Designing indexes.
- Writing SQL statements.
- Influencing access path selection.
- Creating plan hints in a visual editor.
- Customizing and evaluation your own index designs before deploying
them to the data server.