Editing Collect Settings for a Single Statistic - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
You can only edit collect settings for a single statistic.
  1. From the Statistics tab, select a database row.
  2. Select an object row.
    The Statistics view appears.
  3. Do one of the following to edit a single statistic:
    • Click and click Edit Collect Settings.
    • Click a statistic row which displays the Statistic Details view, and click Actions > Edit Collect Settings
  4. To define the collect settings, do any of the following:
    • Select System-defined if you want Teradata Database to decide the settings.
    • Select User-defined if you want to specify the settings.
    • Select None if you do not want thresholds or a sampling method.
  5. If you select User-defined, edit the following settings:
    Option Setting Description
    Threshold Collect age threshold A collection is not performed if the last collection was done within the specified number of days.
    Data change threshold A collection is not performed unless the data set has changed at or beyond the specified percentage since the last collection.
    Sampling Sampling method A histogram is generated using the specified percentage of the actual data.

    For more information about sampling, see Teradata® Database Administration.

    Histogram Max interval Specify the maximum number of histogram intervals to be used for the collected statistics.
    Max value length Specify the maximum size for histogram values.

    For single-character statistics on CHARACTER and VARCHAR columns, specify the number of characters, otherwise specify the number of bytes.

  6. Click OK.