Viewing an Explain Plan

Previous
Previous
Next
Next

To view the Explain Plan:

  1. On the Database Home Page, click the SQL icon.

  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.