16.10 - Approaches to Automating Statistics Collection - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval

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 ensure 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 ensure that 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.