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

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
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.