Use Teradata VE to Insert an Execution Plan into a QCD - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use Teradata VE to Insert an Execution Plan into a QCD

Use this procedure to insert a plan into a QCD using Teradata Visual Explain.

To insert an execution plan into a QCD

Connect to Teradata Database before inserting an execution plan.

1 From the menu bar, click Tools>Execute SQL.

The Execute SQL window opens.

2 Do one of the following to execute a query containing the INSERT EXPLAIN statement:

  • To select a query to be executed from a file, click File>Open Query.
  • Enter the text for the query in the Query window.
  • 3 Click File>Execute Query.

    The results of the query appear in the Answer Set window.

    4 From the menu bar, click File > Close to close the Execute SQL window.