Toad World Blog

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

How to Shorten a Long Optimization Time