Using Explain Plan

You can view the explain plan the Oracle Optimizer uses to run your SQL command. It is not necessary to execute the command to view the explain plan.

Topics:

• Viewing an Explain Plan

• About Explain Plan Pane

Viewing an Explain Plan

To view the Explain Plan:

1. On the Workspace home page, click SQL Workshop and then SQL Commands.

   The SQL Commands page appears.

2. Enter or load the command whose plan you want to view.

3. Click the Explain tab.

   The explain plan used by the optimizer appears in the display pane.

About Explain Plan Pane

The Explain Plan pane shows the plan used by the Oracle Optimizer to run your SQL command. It typically displays the Query Plan, Index Columns and Table Columns used.

Description of the illustration explain_tab.gif

On the Explain Plan pane you can:

• View object definitions. Click the object name in Query Plan to display the object definition in the Object Browser.

• View index definitions. Click the index name in Table Columns to display the index definition in the Object Browser.