Toad and the SQL Optimizer

The SQL Optimizer is part of a larger SQL tuning tool sold by Dell Software. The Toad team put part of this package in Toad.

The SQL Optimizer runs your SQL with a variety of options that include various hints and SQL rewrites to find the optimal performing SQL rather automatically.

To start SQL Optimizer, click on the SQL Tuning button Image and select SQL Optimizer from the list of options that then appears or use Database → Optimize → Auto Optimize SQL (see Figure 10.26).

Image

FIGURE 10.26 Auto Optimize SQL

Tip

Notice the ...

Get Toad for Oracle Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.