Proactive query tuning for application developers
Optim Query Tuner for DB2 for z/OS helps developers create efficient queries and build tuning skills.
Optim Query Tuner for DB2 for z/OS cuts cost and improves performance by providing expert advice on writing high quality queries and improving database design. Its easy-to-use advisors can help developers to write more efficient SQL queries.
Optim Query Tuner for DB2 for z/OS
Features and benefits
Both novice and expert SQL developers and DBAs will find facilities designed to help them develop better performing SQL code.
Optim Query Tuner captures and analyzes queries from a variety of sources:
Optim Query Tuner helps reduce downstream risks and costs provides providing expert query tuning advice
Optim Query Tuner includes the following tools and advisors:
In addition, Query Tuner for DB2 for z/OS includes the ability to capture the query environment for users to visually add Optimization Hints.
Optim Query Tuner fosters cross-role collaboration.