SQL Optimizer Coffee Break Bytes

Home

Products

Community

Knowledge

Downloads

Hello, you are not logged in. Login or sign up

Knowledge >> Toad Knowledge >> Coffee Break Bytes >> SQL Optimizer Coffee Break Bytes


		SQL Optimizer Coffee Break Bytes

	Got five minutes? Learn a little about SQL Optimizer. Quest SQL Optimizer automatically analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL collections from the SGA. You may need to disable your browser pop-up blocking to view the flash demos.


		Obtaining High-Performing and Scalable SQL for Your Oracle Database

Posted: 04/08/2008

Quest SQL Optimizer for Oracle provides seamless integration with Benchmark Factory for Databases to validate SQL scalability and performance. With Benchmark Factory for Databases, developers and DBA's can create tests with the desired user load, test length and latency options. When the test completes, users can analyze SQL statements for scalability and determine the optimal SQL for performance.


		Batch Optimizer

Posted: 04/01/2008

The Batch Optimizer in Quest SQL Optimizer for Oracle is included with Toad™ For Oracle Xpert edition.

With Batch Optimizer users can:

Send PL/SQL from Toad to the Batch Optimizer.
Continue working while the Batch Optimizer finds the SQL statements, optimizes them, and tests to see which alternative is faster the original SQL.
Create a script with optimized SQL to replace original PL/SQL code.