Viewing Dynamic Execution Plans - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities

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.