IBM Optim Query Tuner and IBM Optim Query Workload Tuner cut costs and improve performance by advising developers on writing high-quality queries during development. They also provide a facility for identifying and tuning poorly performing queries that have been deployed into production.
- With the query tuner client you can:
- View formatted query text.
- View and compare access plan graphs.
- Get statistics recommedations.
- Generate query reports.
- Capture query environments
- With Optim Query Tuner for DB2 for Linux, UNIX, Windows, or Optim Query Tuner for DB2 for z/OS you can:
- View queries with statistics annotations
- Get index recommendations.
- Get query writing recommendations.
- Get access path recommendations.
- Propose and validate indexes (DB2 for z/OS only).
- Create, validate, and deploy plan hints (DB2 for z/OS only).
- With Optim Query Workload Tuner for DB2 for z/OS you can:
- Monitor query workloads on DB2 9 for z/OS.
- Capture and tune query workloads on DB2 for z/OS.
Learn more.