Main » SQL Optimizer Product Information

Quest® SQL Optimizer for Oracle Modules

Quest® SQL Optimizer for Oracle maximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. Quest SQL Optimizer automatically analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL collections from the SGA. The process of identifying and optimizing problematic SQL from multiple source code locations is completely automated. Optimizing tens or hundreds of SQL statements, database objects, and source code files is as easy as just submitting the SQL code to Quest SQL Optimizer for Oracle and letting it do the work for you. Quest SQL Optimizer also provides a complete index optimization and plan change analysis solution, from index recommendations for single or multiple SQL statements to simulated index impact analysis, through comparison of multiple SQL execution plans.

Quest SQL Optimizer for Oracle contains the following modules:

The Batch Optimizer (Batch Optimizer tab) automates the process of identifying problematic SQL directly from multiple database objects or files, optimizing the SQL to find alternative ways to rewrite a SQL statement, and testing the alternative SQL to find the fastest statement. Once it has identified the fastest alternative, you can generate a script to replace your original source code with best SQL statements.

 

The SQL Scanner (SQL Scanner tab) extracts SQL statements from database objects and source code and identifies SQL statements that are likely to be causing performance problems.

 

The SGA Inspector (SGA Inspector tab) captures SQL statements that are currently running or those that have been executed in the past along with the corresponding runtime statistics to find the SQL statements that are consuming the most system resources.

 

The Tuning Lab (Tuning Lab tab) contains the SQL Optimizer, the Index Expert, Best Practices and Deploy Outlines. The SQL Optimizer transforms the SQL syntax and applies Oracle hints to find alternative SQL statements and then tests the alternatives to find the best alternative for your database environment. The Index Expert generates index sets for a SQL statement and then tests to find the best set. Best Practices recommends database changes to improve performance. Deploy Outlines creates stored outlines to improve the performance of applications where you cannot replace the SQL statement in the source code.

 

The Global Indexing (Indexing tab) generates one index set for a group of SQL statements and then executes the SQL statements with and without the proposed index set to determine performance improvement.

 

The Impact Analyzer (Impact Analyzer tab) keeps track of execution plan changes to allow you to estimate the impact on SQL statements performance due to database changes. Different database scenarios can be simulated and a group of SQL statements can be selected that will give you a good representation of what will happen if the database change actually occurred. For each database scenario, the SQL statements' execution plans are retrieved and analyzed.

 

The Outline Manager (Outlines tab) enables you to easily manage stored outlines.