16.20 - 16.50 - Teradata Database Prerequisites for Analyze Jobs - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)

Some analyze job options require that Teradata Database query logging (DBQL) features be enabled. For the analyze job options that you plan to use, you must enable the associated database feature prior to running the job.

Before running an analyze job that has the Evaluate stat usage and staleness and find missing stats to collect check box selected and the Use DBQL option selected, enable query logging with the STATSUSAGE option (XMLPLAN is optional) for the objects being analyzed. These options enable the analyze job to identify statistic usage and make recommendations about new statistics that should be collected as reported by the Optimizer and to identify stale statistics. The query logging features should be enabled for at least one week prior to running the analyze job.

Before running an analyze job that has the Evaluate stats to determine if they should be collected or deactivated check box selected, enable query logging with the USECOUNT option for the objects being analyzed. This option enables the analyze job to identify inactive statistics. The query logging feature should be enabled, prior to running the analyze job, for a period of time that is equal to the period specified in the Recommend stats for deactivation when inactive for option.

For more information, see Teradata® Database Release Summary and Teradata® Database Administration.