Teradata Database Prerequisites for Analyze Jobs - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

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.