Overview
InfoSphere Optim™ Query Workload Tuner for DB2 for Linux, UNIX and Windows provides expert recommendations to DBAs to help improve performance of a query workload.
InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows provides expert recommendations to maximize application performance, reduces specialized skill requirements, and reduces the total cost of ownership.
Group your SQL statements into workloads to tune, compare and track performance improvements.
Manage and monitor the performance of SQL queries and workloads to proactively optimize physical database design and improve performance.
Get advice on indexes, statistics, and statistical views of a workload and set of queries.
Contextually launch InfoSphere Optim Query Workload Tuner from IBM Data Studio and gain immediate insight into performance enhancements during development.
Provides virtual-index what-if analysis and visual plan hints that help improve the performance of the queries.
Reduce downtime and associated costs.
Languages supported: English, French, Russian, Korean, Spanish, German, Hungarian, Czech, Italian, Polish, Chinese – Traditional, Chinese – Simplified and Portuguese – Brazilian.
Product framework
Family overview
Boost performance, empower collaboration, and improve governance across applications, databases and platforms.

