Quest Central® for DB2

SQL Tuning

Quest Central® for DB2's SQL Tuning is the most comprehensive tuning environment available for both DB2 distributed and mainframe environments. The tuning lab is scenario-driven, which allows for modifications of the SQL statement while keeping the original intact. Quest Central gives you fast, intelligent advice on how to tune offensive SQL statements. With a click of a button, it rewrites your SQL statement to implement the advice you select.

Key Benefits

• Reduces learning curve by providing intuitive SQL tuning lab regardless of what platform DB2 resides
  
• Lower I/O and CPU costs with optimized SQL
  
• Built-in expertise removes time-consuming analysis
  

Key Features

• Comprehensive tuning lab provides all the information you need on a selected statement including access plan and object statistics
  
• Context-sensitive, scenario-driven expert advice offers advanced recommendations for strategic tuning based on the specific function of the database within the system
  
• Graphical scenario comparison allows you to immediately visualize the performance impact of changes to your SQL statement
  
• Supports DB2 on both distributed and mainframe platforms
  
• Analyze the affect that a new index will have on SQL without actually creating the index (distributed platforms)
  
• Analyze the access path currently in use by bound SQL as well as the access path should you choose to rebind (mainframe only)
  
• No Mainframe Install Required

The SQL Tuning module is integrated with the other Quest Central components: Database Administration, Performance Diagnostics, and Space Management.