Quest SQL Optimizer Maximize SQL Performance Quest SQL Optimizer automates the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. Quest SQL Optimizer automatically analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL collections from the SGA. The process of identifying and optimizing problematic SQL from multiple source code locations is completely automated. Optimizing tens or hundreds of SQL statements, database objects, and source code files is as easy as just submitting the SQL code to Quest SQL Optimizer and letting it do the work for you. Quest SQL Optimizer also provides a complete index optimization and plan change analysis solution, from index recommendations for single or multiple SQL statements to simulated index impact analysis, through comparison of multiple SQL execution plans.