Analyze Jobs - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

Analyze jobs allow you to evaluate statistics status and get statistic-related recommendations. Analyzing objects enables you to determine where additional statistics may be useful and identify existing statistics that are used frequently or are stale.

You can create new jobs, edit existing jobs, and cancel jobs.

When you create an analyze job, you:
  • Specify the database objects the job analyses.

    You can define the scope to include all objects or just a few.

  • Select functions to be performed when the job is run, such as:
    • Evaluate statistics usage and staleness and find missing statistics to collect
    • Evaluate statistics to determine if they need to be collected or deactivated
    • Automate existing statistics
  • Specify when and how often the job runs.
The performed functions when the job runs are described in the following table.
Function Description
Evaluate statistics usage and staleness and find missing statistics to collect Determines which statistics are used, which statistics are stale, and which new statistics should be collected to help the Optimizer make better decisions.

The job report lists statistics that are stale and statistics that do not exist but the Optimizer would have used them if they had existed. If the Use DBQL option is enabled, the job report lists statistics that were used by the Optimizer.

After the job runs, collect recommendations are created.

Evaluate statistics to determine if they should be collected or deactivated Determines statistics that are useful to the Optimizer and recommends if statistics should be activated or deactivated.

The job report lists statistics that have not been used by the Optimizer for the specified period of time. These statistics can be flagged as inactive so that they are no longer collected by collect jobs. Also reports on statistics that have been flagged as inactive but that have been used by the Optimizer over the specified period.

After the job runs, deactivate and reactivate recommendations are created.

Automate existing statistics Reports on statistics that have not yet been automated.

The job report lists statistics that have not been automated with an option to include only new statistics since a particular date or only those statistics that are used as determined by the first function listed before.

After the job runs, automate recommendations are created.

When you specify the objects the job analyse, you can use existing object lists and custom object lists. An object list is a list of database objects used for a job scope. An existing list is a custom list from another job or a list created outside of the Stats Manager portlet.