Features and Benefits

Batch Optimization
The batch optimizer automatically scans and identifies the problematic SQL in multiple database objects, source code files and SGA collections then optimizes them. Users can control the scope of automation, as needed, in each step of the optimization process. The batch optimizer can also automate the entire cycle of SQL performance tuning.

Stored Procedure Optimization
Optimizing stored procedures requires painstaking, statement-by-statement scrutiny and analysis. Through the batch optimization process, these database objects can now be tuned in their entirety drastically expanding the scope of performance tuning

Code Replacement
When optimization is complete, stored procedure scripts are generated for implementing the changes to the SQL within these objects. If SQL is scanned and optimized from an application code file, replacement files with updated embedded SQL are offered to substitute for the pre-optimized code files.

Indexing Strategy Analysis
Through Index Expert index options can be automatically generated for individual SQL statements; and, through Global Indexing, index options can be automatically generated for groups of SQL. After these indexes are generated, it is important to see the affect each set has, not only on the SQL for which they were created, but also for all SQL being run on the database completely automating indexing strategies.

Impact Prediction

Impact Analysis