Before deleting execution plans, go to Cleaning Up a QCD and perform steps 1 through 3.
- From the Cleanup QCD dialog box, click Execution Plans.
The Select Execution Plans to Delete dialog box appears.
[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.
- [Optional] To delete DynamicXML plans, select Browse Dynamic. Dynamic XML plans are listed in the Execution Plans list.
Select the plans to delete.
Execution plans with a gray background are referenced in one or more workloads and are not deleted.
[Optional] To see complete statement text:
- Select a statement.
For more information on the Statement Text dialog box, see Viewing Statement Text.
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.
- Click Cancel to close the Select Execution Plans to Delete dialog box and return to the Cleanup QCD dialog box.