Teradata Database Prerequisites for Analyze Jobs

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

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 the Teradata Database Release Summary and Teradata Database Administration.