The export operation for workloads stores the information in an internal Teradata Visual Explain format (.mcf file).
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, select Workloads.
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 Workloads to Export dialog box appears.
4 Click Browse QCD.
The workloads are inserted.
5 [Optional] To view the workload statements and the complete statement text of each query:
a Click .
The Workload Statements dialog box appears.
b Click the statement to view.
The full statement text appears in the Statement Text box.
c Click OK to close the Workload Statements dialog box.
6 [Optional] To view recommendations when recommendations exist on a particular workload:
a Select the workload.
b Click View Recommendations.
The View Recommendations dialog box appears and displays details of the index recommendation.
Column |
Description |
Database Name |
Name of the database the table belongs to. |
Table Name |
Name of the table on which the index recommendations were made. |
Index Type |
Type of the index recommended. Possible values are USI, VOSI, NUSI and HOSI. For more information, refer to the Index Recommendations section in SQL Request and Transaction Processing B035-1142. |
Index DDL |
Index recommendation DDL statement text used to create/drop the index. |
Statistics DDL |
Statistics recommendation DDL statement text used to create/drop the statistics. |
7 Select the workloads to export.
8 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 confirmation message appears.