Graphical Explain Plan

Using Graphical Explain Plan

By default, the Graphical Explain Plan displays the operation nodes horizontally, with the root node of the tree on the right-side of the screen. Sections of the tree within a node can be collapsed or expanded by clicking the minus or plus sign for the node.
  1. You can zoom in or zoom out on the Graphical Explain Plan using the mouse or the keyboard +/- keys. You can also click and drag the plan within the viewport.

    An overview section is located in the bottom-right corner of the content area. It provides a visual representation of the positioning of the viewport with respect to the overall content of the plan.

  2. Click a plus sign to expand a node and display information for the operation subtree. Click a minus sign to collapse the operation subtree beneath a node.

  3. Hover over a node to view the operation name and estimated row count. Click a node to display additional information about the operation in a message box. Click Close to close the message box.

  4. Click Rotate (to the right of the Graphical Explain menu) to rotate the entire explain plan 90 degrees counterclockwise.

    Click Rotate subsequently to move the explain plan another 90 degrees counterclockwise. In any position of the tree, click the plus or minus sign to expand or contract the subtree of an operation node.

  5. Click the Back arrow at the top-left corner of the page to go back to the SQL Monitoring tab.