Toad World

Understand the optimization process used in Quest SQL Optimizer

Testing SQL Alternatives That Contain Variables

Testing SQL Alternatives in a Development Environment

Table Join Syntax

Rearranging the Driving Path

Optimizing SQL statements with a VIEW

How to use the Batch Optimizer with Rule Based Optimizer

Generating more SQL alternatives

Viewing the SQL Alternatives and Execution Run Time Statistics

Using Oracle Optimization Hints When Tuning SQL

Selecting Which SQL to Execute First

Performance Improvement Expectation