IBM Optim Query Tuner

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.