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.
-
Depending on which method you choose to evaluate statistics, select one of these procedures:
Method Procedure Evaluate stat usage and staleness and find missing stats to collect and
Use DBQL
Enable query logging with the STATSUSAGE option for the objects being analyzed. XMLPLAN is optional. The query logging features should be enabled for at least one week prior to running the analyze job. See the Teradata Database Prerequisites for Analyze Jobs section in the Teradata Viewpoint User Guide for more information.Evaluate stats to determine if they should be collected or deactivated Enable query logging with the USECOUNT option for the objects being analyzed. 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.