Approaches to Automating Statistics Collection - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

You can use a submit-based approach, analyze-based approach, or a combination of both approaches, to automate statistics collection using the Stats Manager portlet.

Approach Description
Submit-Based Use this approach to:
  • Submit all automated statistics for frequent collection
  • Employ the Optimizer to determine if a statistic needs to be collected
Analyze-Based Use this approach to:
  • Analyze the importance and staleness of statistics
  • Prioritize statistics submitted for collection based on the analyze results
Combination Use a combination of both submit-based and analyze-based approaches to make sure data is collected on stale statistics on a timely basis.
Prior to implementing a statistics collection approach, you must do the following:
  • Use the automate options to approve the statistics you want to automate.
  • Create collect jobs to make sure all automated statistics are associated with a collect job.

    All automated statistics are associated with a collect job when 100% of automated stats have collect jobs displays on the Statistics by Database view on the Statistics tab.