Exporting Workloads - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities

Before exporting execution plans, go to Exporting QCD Data to a Text File and perform steps 1 through 4.

The export operation for workloads stores the information in an internal Teradata Visual Explain format (.mcf file).

  1. In the Export QCD dialog box, select Workloads.
  2. Click Export. The Save As dialog box appears.
  3. To save the QCD information:
    1. Enter a name for the file in the File name box.
    2. 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.

      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:
    1. Click . The Workload Statements dialog box appears.
    2. Click the statement to view. The full statement text appears in the Statement Text box.
    3. Click OK to close the Workload Statements dialog box.


  6. [Optional] To view recommendations when recommendations exist on a particular workload:
    1. Select the workload.
    2. 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.
    To stop the export action immediately, click Abort. A confirmation message appears.