Submit-Based Approach - 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

The submit-based approach employs the Optimizer to determine if a statistic needs to be collected. You can enable collect thresholds to prevent repeat collection of statistics that were recently collected or have not changed significantly.

Following is an overview of the tasks employed in this approach:
  1. Change the Collect age threshold and Data change threshold on the Edit Collect Settings dialog box to skip the collection of statistics that were recently collected or have not changed significantly.
  2. Run the collect jobs frequently.

    When a job is run, the Optimizer determines which statistics to collect, based on the threshold settings.

    Review the Collect Job report for a list of collected and skipped statistics.

  3. Verify that all the automated statistics are submitted for collection.
    In the Statistics by Database view, examine the Max Submit Age metric for databases or Submit Age metric for objects. If the value is greater than the expected frequency, check the following:
    • Statistics are associated with a collect job
    • Collect job is scheduled to run with the expected frequency
    • End state of the collect job is Complete or Partially Complete.

      If the job is Partially Complete and not scheduled to resume, the job duration may be too short.