Viewing Dynamic Execution Plans

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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

  1. In the Tree View, right-click the Dynamic Plans node to display a shortcut menu.
  2. 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.
  3. Right-click the Plan Node and select Add to add the single plan to the Selected Execution Plans list.
  4. [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.

  5. Click Open to display the plans.