Report button - A report button was added to the Tuning Lab and the Global Indexing toolbars.While the optimization, index generation, or Best Practices is in progress in the Tuning Lab. Options window - You can now open the Options (formerly called Preferences) window.So now you no longer need to select which algorithm to use. This version the two algorithms for scanning SQL have been combined into one algorithm, Within the programming code, typically used for Java, C, and Perl source codes. The other one extracted SQL statements within quotes and all on one command line One SQL algorithm extracted embedded SQL statements such as in PL/SQL. Consolidated SQL scanning algorithms - In previous versions, there were two SQL scanningĪlgorithms.Database connections - In each module you can now connect to different databases sinceĮach module has its own database connection.Quest SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations for multiple SQL statements to simulated index impact analysis, through comparison of multiple SQL execution plans.

Optimizing tens or hundreds of SQL statements, database objects, and source codes is as easy as just submitting the SQL code to Quest SQL Optimizer for Oracle and letting it do the work for you. Whether you are a developer, DBA or performance tuner, you can let Quest SQL Optimizer analyze and optimize in batch all problem SQL from multiple sources and then Quest SQL Optimizer provides you with the replacement code with optimized SQL statements. The process of optimizing problematic SQL from multiple source code location is completely automated. Quest SQL Optimizer automatically analyzes, rewrites and evaluates SQL statements within multiple database objects, files, or SQL collections from the SGA. 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. Welcome to Quest SQL Optimizer for Oracle Quest SQL Optimizer for Oracle 7.0 - Release Notes

Quest sql tuning for oracle