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 the Explain tab.

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