Automating Statistics - 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
When automated, statistics are approved for collection by collect jobs. You can automate existing statistics using an analyze job or you can manually automate statistics as described in the following table.
  1. From the Statistics tab, do any of the following:
    Scope Description
    System To automate all statistics within a Teradata Database system:
    • From the Statistics by Database view, click Actions > Automate System.
    Database To automate all statistics within a single database, do one of the following:
    • From the Statistics by Object view, click Actions > Automate Database.
    • From the Statistics by Database view, click next to the database name and click Automate.
    To automate all statistics within multiple databases:
    1. From the Statistics by Database view, click the Table Actions list and click Automate.
    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 automate all statistics for a single object, do one of the following:
    • From the Statistics view, click Actions > Automate <object type>.
    • From the Statistics by Object view, click next to the database name and click Automate.
    To automate all statistics for multiple objects:
    1. From the Statistics by Object view, click the Table Actions list and click Automate.
    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.
    Statistic To automate a single statistic, do one of the following:
    • From the Statistics view, click next to the database name and click Automate.
    • From the Statistic Details view, click Actions > Automate Statistic.
    To automate multiple statistics for the same object:
    1. From the Statistics view, click the Table Actions list and click Automate.
    2. Do one of the following:
      • Select the check box in the column heading to select all statistics.
      • Select the check boxes for specific statistics.