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.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.
Feature-rich relational database known for its high performance and excellent concurrency
