Approaches to Automating Statistics Collection - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

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.