Viewing the Execution Plan from a QCD Database (Workload) - 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 inserting an execution plan into a QCD using INSERT EXPLAIN, view the Explain results graphically or textually.

  1. Click .

    The Select Execution Plan(s) to Open window appears.



  2. Use the following steps to select a QCD:
    1. In the tree view, right-click the Query Capture Databases node to display a shortcut menu.
    2. In the shortcut menu, select Browse QCD to list all available QCD names under the Query Capture Databases node.


  3. Select a QCD from the list.
    1. Right-click a QCD name and select Browse Plans.


      The Browse QCD Plans dialog box appears.

      Browse QCD Plans

    2. Use one of the following options:
      • Enter the workload name in the Workload box.
      • Click the arrow button in the Workload box to select a workload from a list of available workloads.
      • Click the XML Plans check box to view XML plans available in the selected QCD.
        This option is available only for Teradata Database version 13.10 and later.
  4. Click the OK button to retrieve the specified plans.
  5. Select the checkbox next to one or more plans in the Available Execution Plans list.
    Click Add All to add all available plans to the Selected Execution Plans list, and skip step 6.
  6. [Optional] To see complete statement text, select a QueryID in the Available list, right-click and select the Statement Text menu item for a specific QueryID.

    For more information on the Statement Text dialog box, see Viewing Statement Text.

  7. Click Open to display the plans. The plans appear in the main window. See Summary Information Window.