Tools | SQL Optimizer
Tools | SQL Optimizer
SQL Optimizer provides context-sensitive tuning advice for SQL statements based on the Oracle execution plan and the database structure.
Note: In earlier versions of Spotlight on Oracle, SQL Optimizer was also known as SQLab or SQL Tuning.
Before you open SQL Optimizer
- Ensure SQL Optimizer is installed on your machine.
- Ensure you have DBA privileges for the database you are diagnosing.
Ways to open SQL Optimizer
| Location | Instruction |
|---|---|
| From anywhere in Spotlight. |
Click Tools | SQL Optimizer. |
|
From Drilldown Pages:
|
Click |
.