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.
- Reduces costs and risks by enabling developers to tune SQL during development, while problems are still relatively inexpensive to fix and before they cause a costly outages or performance issues.
- Operates within a familiar Eclipse development environment and features seamless integration and natural launch points within Optim Development Studio.
- Accelerates query tuning analysis by providing expert advice and recommendations.
- Fosters collaboration among developers and DBAs; DBAs can extend query tuning advice to SQL Workloads (multiple queries) by using Optim Query Workload Tuner for DB2 for z/OS
製品について
ご購入 Optim Query Tuner for DB2 for z/OS
初年度の IBM ソフトウェア・サブスクリプション & サポートは製品価格に含まれています。
ご購入には諸手続きが必要になりますので、弊社窓口までお問い合わせください。
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:
Packages, SQL stored procedures, triggers, and user-defined functions (UDFs) - all from within the Data Source Explorer in the Eclipse environment
The integrated query editor and routine editor within IBM Data Studio or IBM Optim Development Studio
The SQL Outline and the Java editor within Optim Development Studio
The DB2 catalog, for database packages and stored procedures
Optim Query Tuner helps reduce downstream risks and costs provides providing expert query tuning advice
Optim Query Tuner includes the following tools and advisors:
Access Plan Graph: Provides a graphical view of the access plan chosen by the optimizer.
Query Annotation: Formats the query with collapsible sections and highlighting to improve readability and navigation through complex queries. Provides catalog statistics and cost estimates for the tables and columns used in the query.
Query Advisor: Provides query rewrite advice based on a set of best practice rules.
Access Path Advisor: Provides advice on how to resolve access path issues that may result in poor performance.
Statistics Advisor: Provides advice on missing, outdated and conflicting statistics and suggests additional statistics that should be gathered to improve individual query performance. Use the statistics advisor to tune the DB2 auto-stats profile.
Index Advisor: Provides advice on new indexes that may improve performance for individual queries as well as the ability to define user-defined virtual indexes.
Query Report: Simplifies collaboration identifying key statistics, access path information, and physical database design information related to a query.
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.
Optim Query Tuner helps developers and DBAs speak the same language with regard to query tuning.
Integration with Optim Development Studio lets developers or DBAs invoke Optim Query Tuner in context from any SQL statement, whether the developer is working in the Java editor or the DBA is working with SQL packages.
Streamline connection management with common connections across Optim Query Tuner, Optim Development Studio, Optim Database Administrator, and InfoSphere Data Architect.