Viewing the Execution Plan from a QCD Database (Different Server)

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 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 (Different Server) window appears.

    Select Execution Plan(s) to Open (Different Server)

  2. 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 Query Capture Databases node.
  3. Load plans from a different server:
    1. Click the Connect button in the toolbar of the Open Plan window.
    2. Enter logon information.
    3. In the shortcut menu, select Browse QCD to list all available QCD names under Query Capture Databases node.
  4. To view the available XML plans in the selected QCD, do the following:
    1. Under the Query Capture Databases node, select a specific QCD.
    2. Right-click the QCD to display the shortcut menu and select Browse Plans to display the Browse QCD Plans dialog box.
    3. Select XML Plans to view the available XML plans in the selected QCD.
      Browse QCD Plans

      This option is available only for Teradata Database version 13.10 and later.
  5. Click OK to retrieve the specified plans.
  6. Select the check box 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 the next step.
  7. [Optional] To see complete statement text, select a QueryID in the Available list, right-click to select the Statement Text menu item for a specific QueryID (see Viewing Statement Text).
  8. Click Open to display the plans.