Viewing an Explain Plan

Previous

Next

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 Explain which is located between the command editor and the display pane.

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