Quest SQL Optimizer for Oracle proactively identifies potential performance issues and automates SQL optimization by scanning and analyzing running SQL statements, PL/SQL or other source code. It automates SQL statement optimization by analyzing the original SQL statement and using artificial intelligence to exhaustively rewrite the syntax and apply the Oracle optimization hints.
v8.5 [Sep 23, 2011]
The new Optimize Indexes module in SQL Optimizer allows you to evaluate and improve indexes for a SQL workload or for any group of SQL statements.
You can instruct SQL Optimizer to gather SQL statements from a SQL workload source. SQL Optimizer then evaluates the SQL workload and recommends the best set of indexes to optimize database performance for that workload.
Use SQL Optimizer to collect SQL from any of the following sources:
An Oracle Automatic Workload Repository (AWR)
A Foglight Performance Analysis Repository
An Oracle System Global Area (SGA)
Scan Code (from source code, a database object, a file, or the clipboard)
SQL Optimizer uses proprietary, state-of-the-art algorithms to continuously improve its index evaluation results. So, the longer the evaluation process runs, the better the result. In addition, SQL Optimizer updates its recommendations over time to reflect any changes in data distribution or configuration.
You can schedule the evaluation process to run at defined intervals and to automatically stop when specific goals are met.
After new indexes are created, send them to Analyze Impact to determine the impact of creating the indexes on database performance.
The functionality of the Advise Indexes module has been superseded by the new Optimize Indexes module.
Feature-rich relational database known for its high performance and excellent concurrency
