Using Explain Plan

Viewing an Explain Plan

To view the Explain Plan:

1. Click the SQL Workshop icon on the Workspace home page.

2. Click the SQL Commands icon.

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

4. Click Explain which is located between the command editor and the display pane.

   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.

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.