Deleting Execution Plans from a QCD - 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 deleting execution plans, go to Cleaning Up a QCD and perform steps 1 through 3.

A QCD must be cleaned up before deleting associated execution plans.
  1. From the Cleanup QCD dialog box, click Execution Plans.
  2. Click OK.

    The Select Execution Plans to Delete dialog box appears.



  3. [Optional] To delete QCD XML plans, select the QCD XML Plans check box.

    XML plans are listed in the Execution Plans list for the selected QCD. Plans are listed based on the range given in the Query ID field.

  4. [Optional] To delete DynamicXML plans, select Browse Dynamic. Dynamic XML plans are listed in the Execution Plans list.
  5. Select the plans to delete.
    Execution plans with a gray background are referenced in one or more workloads and are not deleted.
  6. [Optional] To see complete statement text:
    1. Select a statement.
    2. Click .

      For more information on the Statement Text dialog box, see Viewing Statement Text.

  7. Click Delete. A message appears indicating the status of the cleanup process.
    To stop the delete action immediately, click Abort. A message appears indicating the delete action has been canceled.
  8. Click Cancel to close the Select Execution Plans to Delete dialog box and return to the Cleanup QCD dialog box.