Toad World Blog

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

Accounting for Network When Comparing SQL Run Times

Display Order for Alternatives SQL Statements

Criteria for Terminating SQL in the Batch Run

Criteria for Selecting Best SQL

Accounting for Other Activity on the CPU When Comparing SQL Run Times

Accounting for Caching When Comparing SQL Run Times