Author: Steve Hilker

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

Selecting Which SQL to Execute First

Using Oracle Optimization Hints When Tuning SQL

Generating more SQL alternatives

How to use the Batch Optimizer with Rule Based Optimizer