Quest SQL Optimizer for Oracle download

v8.8 [Jun 25, 2013]
1. Optimize SQL
- The algorithm used to determine batch run execution order (when the Intelligent order option is selected) has been enhanced to reduce the time it takes to find the best alternative. This is done by increasing the likelihood of executing the most favorable alternatives early in the batch run process. This enhancement applies to the Batch Run and Auto Optimize methods of optimization.
2. Integration with Toad for Oracle
- For Toad for Oracle users, SQL Optimizer now uses your Toad login script to set up your environment when you invoke SQL Optimizer using the Optimize Current SQL or the Scanning options in Toad.
- If you are using a login script for Oracle TEMP tables in Toad, when invoked from Toad, SQL Optimizer will also use the log-in script.
- These enhancements are particularly useful if you are an Oracle Application user who frequently takes advantage of the Toad login script feature.
3. User Interface
- This release includes several new keyboard shortcuts for navigating the SQL Optimizer user interface. You can use these keys and key-combinations to open drop-down lists, activate buttons and links, scroll and refresh, and move between UI elements.

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.