Toad World Blog

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

How to Shorten a Long Optimization Time

How to generate SQL alternatives without Oracle hints

How to generate fewer SQL alternatives