Deleting Execution Plans from a QCD

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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.