Deleting Execution Plans from a QCD - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

A QCD must be cleaned up before deleting associated execution plans.

Before deleting execution plans, go to “Cleaning Up a QCD” on page 99 and perform step 1 through step 3 of the procedure.

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 the Browse Dynamic button. Dynamic XML plans are listed in the Execution Plans list.

5 Select the plans to delete.

Note: Execution plans with a gray background are referenced in one or more workloads and are not deleted.

6 [Optional] To see complete statement text:

a Select a statement.

b Click .

For more information on the Statement Text dialog box, see “Viewing Statement Text” on page 80.

7 Click Delete.

A message appears indicating the status of the cleanup process.

Note: 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.