Cleaning Up 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

Clean up a QCD to get rid of unwanted execution plans or database objects residing in the QCD.

Connect to Teradata Database before cleaning up a QCD.

  1. Click Tools > Control Center. The Control Center dialog box appears, and the Manage QCD tab is selected.
  2. Click Cleanup QCD.

    The Cleanup QCD dialog box appears.



  3. In the QCD Name box, do one of the following:
    • Select a QCD to clean up.
    • Click for a list of QCDs that are available on the server.
  4. From the Cleanup QCD dialog box, click one of the following:
    • Execution Plans

    • Database Objects

    • Workloads

    • Entire Database

    • Demographics

  5. Go to the procedure that corresponds to the option selected in the previous step: