Analyze Statistics | Teradata Viewpoint - Analyzing Statistics - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
ohm1711972149764.ditamap
dita:ditavalPath
acl1501004736403.ditaval
dita:id
ulq1467244577135
Product Category
Analytical Ecosystem
Some analyze job options require that Analytics 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.
  1. 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 "Analytics Database Prerequisites for Analyze Jobs" in Teradata® Viewpoint User Guide.
    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.