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

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
You can edit collect settings for multiple statistics within a Teradata 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 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 Analytics Database to decide the settings.
    • Select None if you do not want thresholds, a sampling method, or histogram.
  3. Click OK.