Editing Collect Settings for Multiple Statistics

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
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 menu 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 menu 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.