DB2 10.5 for Linux, UNIX, and Windows

IBM InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows

IBM® InfoSphere® Optim™ Query Workload Tuner improves performance and cuts costs by helping database administrators and SQL developers optimize the performance of SQL statements in applications that query DB2® databases. Built-in integration with the Data Studio client helps to find problematic queries in development. Database administrators can further tune performance by optimizing statistics, creating or modifying indexes, creating MQTs, converting tables to MDC tables, distributing data across partitions, and creating optimization profiles.