17.10 - Editing Collect Settings for Multiple Statistics - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-2206-101K
Language
English (United States)
You can edit collect settings for multiple statistics within a Teradata Database system, multiple statistics within one or more databases, or multiple statistics for one or more objects.
  1. From the Statistics tab, do any of the following:
    Settings Description
    System To edit collect settings for multiple statistics within a Teradata Database system:
    • From the Statistics by Database view, click Actions > Edit Collect Settings.
    Database To edit collect settings for multiple statistics within a single database, do one of the following:
    • From the Statistics by Object view, click Actions > Edit Collect Settings.
    • From the Statistics by Database view, click next to the database name and click Edit Collect Settings.
    To reset collect settings for multiple statistics within multiple databases:
    1. From the Statistics by Database view, click the Table Actions list and click Edit Collect Settings.
    2. Do one of the following:
      • Select the check box in the column heading to select all databases.
      • Select the check boxes for specific databases.
    Object To edit collect settings for a single object, do one of the following:
    • From the Statistics view, click Actions > Edit Collect Settings.
    • From the Statistics by Object view, click next to the database name and click Edit Collect Settings.
    To edit collect settings for multiple statistics for multiple objects:
    1. From the Statistics by Object view, click the Table Actions list and click Edit Collect Settings.
    2. Do one of the following:
      • Select the check box in the column heading to select all objects.
      • Select the check boxes for specific objects.
  2. To define the collect settings, do any of the following:
    • Select System-defined if you want Teradata Database to decide the settings.
    • Select None if you do not want thresholds, a sampling method, or histogram.
  3. Click OK.