Deleting Workloads - 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

There are several options when deleting workloads. More than one workload can be selected for deletion. Workload information can be deleted without deleting the associated execution plans. One or more selected recommendations can be deleted.

Note: Execution plans referenced in one or more workloads cannot be deleted.

Before deleting a workload, 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 Workloads.

2 Click OK.

The Select Workload Plans to Delete dialog box appears.

3 In the Workload box, do one of the following:

  • Click the Workload arrow to select a workload to delete.
  • Select a workload to delete from a list of all available workloads:
  • i Click .

    i Click .

    ii Select a workload.

    4 Click Browse QCD.

    The queries related to the workload selected in step 3 appear under Execution Plan(s).

    5 [Optional] To delete the execution plans associated with the workload in addition to the workload itself, select the Delete Plans check box.

    6 [Optional] If recommendations exist on a particular workload, click View Recommendations to display the View Recommendations dialog box and additional information.

    For more information about this dialog box, see step 6 on page 113.

    7 [Optional] To see complete statement text:

    a Select a statement.

    b Click .

    The Workload Statements dialog box appears.

    c Select a statement to view.

    The Statement Text box displays the full text.

    d Click OK to close the Workload Statement dialog box.

    8 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.

    9 Click Cancel to close the Select Workload to Delete dialog box and return to the Cleanup QCD dialog box.