Before exporting execution plans, go to Exporting QCD Data to a Text File and perform steps 1 through 4.
The export operation for database objects stores the information in an internal Teradata Visual Explain format, as opposed to text files containing SQL statements that could be executed using BTEQ.
- In the Export QCD dialog box, select QCD Data.
-
Click Export.
The Save As dialog box appears.
-
To save the QCD information:
- Enter a name for the file in the File name box.
-
Click Save.
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.
A progress message appears. When the export is complete, the Control Center dialog box appears.
To stop the export action immediately, click Abort. A confirmation message appears.