Database Prerequisites for Analyze Jobs - 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

Some analyze job options require that 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.