Quest Central® for DB2

Quest SQL Optimizer for DB2

The majority of DB2 application performance problems are the result of poorly written SQL. Flexibility of the SQL language often makes it possible to write a statement in many different ways to achieve the same results set. This flexibility can easily result in statements being written inefficiently. The process of writing and optimizing SQL is a very time consuming, tedious process.

Quest SQL Optimizer for DB2 UDB offers complete SQL performance optimization with proactive detection of inefficient SQL, automated SQL rewrite and benchmarking capabilities. Quest SQL Optimizer maximizes application performance and eliminates problematic SQL before users are affected.

Benefits

• Proactively identifies poor performing SQL code and optimizes it for maximum performance prior to deployment
• Allows inexperienced DBAs and developers to easily write efficient SQL
• Improves performance by automatically rewriting SQL and selecting best alternatives to maximize performance
• Enhances SQL knowledge with in-process training

Features

• Analyzes application code and identifies SQL most in need of tuning
  
• Measures the results of every possible SQL rewrite to identify the optimal way to write a statement, and quantifies its improvement
  
• Highlight differences between bound and current access plans in packages
  
• Benchmark SQL statements to find the most resource intensive statement
  
• Detailed Index analysis:
  
  • Recommends/generates indexes to enhance SQL performance using virtual index simulation
    
  • Analyzes impact of new indexes across entire database
    
  • Identifies unused indexes