Before exporting execution plans, go to Exporting QCD Data to a Text File and perform steps 1 through 4.
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.
- In the Export QCD dialog box, ensure that Execution Plans is selected (default setting).
- Click Export. The Save As dialog box appears.
To save the QCD information:
- Enter a name for the file in the File name box.
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.Select Execution Plan(s) to Export
- Click Browse QCD. The execution plans load.
[Optional] To see complete statement text information:
- Select a statement.
For more information on the Statement Text dialog box, see Viewing Statement Text.To browse XML plans, select the QCD XML Plans check box and click the Browse button.
- Select the plans to export.
A progress message appears. When the export is complete, the Control Center dialog box appears.To stop the export action immediately, click Abort. A message appears indicating the export action has been canceled.