Exporting Execution Plans - Visual Explain

Teradata Visual Explain User Guide

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

The export operation for execution plans stores the information in an internal Teradata Visual Explain format (.mcf file), as opposed to a text file containing SQL statements that could be executed using BTEQ.

Before exporting execution plans, go to “Exporting QCD Data to a File” on page 109 and perform step 1 through step 4 of the procedure.

1 In the Export QCD dialog box, ensure that Execution Plans is selected (default setting).

2 Click Export.

The Save As dialog box appears.

3 To save the QCD information:

a Enter a name for the file in the File name box.

b Click Save.

Note: If an existing .mcf file is selected, a message appears indicating the file already exists. Click Yes to replace the existing file or click No to return to the Save As dialog box and enter a new file name.

The Select Execution Plan(s) to Export dialog box appears.

Figure 29: Select Execution Plan(s) to Export

4 Click Browse QCD.

The execution plans load.

5 [Optional] To see complete statement text information:

a Select a statement.

b Click .

For more information on the Statement Text dialog box, see “Viewing Statement Text” on page 80.

Note: To browse XML plans, select the QCD XML Plans check box and click the Browse button.

6 Select the plans to export.

7 Click Export.

A progress message appears. When the export is complete, the Control Center dialog box appears.

Note: To stop the export action immediately, click Abort. A message appears indicating the export action has been canceled.