After capturing a dynamic (IPE) plan into SystemFE.Opt_XMLPlan_Table, view the Explain results graphically or textually.
Select Execution Plans to View Dynamic Plans
- In the Tree View, right-click the Dynamic Plans node to display a shortcut menu.
- In the shortcut menu, select Browse Dynamic Plans to list SystemFE node and right-click the SystemFE shortcut menu to display all Available Dynamic Plan Names under Dynamic Plans Database Node.
- Right-click the Plan Node and select Add to add the single plan to the Selected Execution Plans list.
-
[Optional] To see complete statement text, select a Request Name in the Available list, right-click to select the Statement Text menu item for a specific Request.
For more information on the Statement Text dialog box, see Viewing Statement Text.
- Click Open to display the plans.