The Optimizer Plan Visualization control provides an interactive and intuitive way to view your plan and statement.
| Menu | Description |
|---|---|
 |
Click to show Analysis of Query for the selected plan. Click View to show the Execution Plan. Click More to show the SQL Statement. |
 |
Click to show the Execution Plan. |
 |
Click to show the operation of each session for the selected plan. Note that you can show/hide columns using Organize Columns. |
 |
Click to show the SQL statement for the selected plan. |
 |
Click to show a tabular view of all objects in use by the plan and the operations they are used in. |
Tip: While the Session Status is running there is an option to View SQL for Batch.
Note: Optimizer Plan Visualization is not available in Playback mode. Display of the SQL Statement is available in Playback mode.