Tag: Toad for Oracle

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

Accounting for Network When Comparing SQL Run Times

Display Order for Alternatives SQL Statements

Criteria for Terminating SQL in the Batch Run