Features and benefits
InfoSphere Optim Query Tuner for DB2 for Linux, UNIX, and Windows cuts cost and improves performance by providing expert advice on writing high quality queries and improving database design. Its easy-to-use advisors encourage developers to write high quality SQL code during development. Built-in integration with IBM Data Studio makes it even easier to find problematic queries in development and launch Query Tuner in the development context. DBAs can further tune performance by optimizing statistics collection and evaluating index suggestions. Both novice and expert SQL developers and DBAs will find facilities designed to help them develop better performing SQL code.
InfoSphere Optim Query Tuner captures and analyzes queries from a variety of sources:
InfoSphere Optim Query Tuner helps reduce downstream risks and costs provides providing expert query tuning advice
InfoSphere Optim Query Tuner includes the following tools and advisors:
InfoSphere Optim Query Tuner fosters cross-role collaboration.