Automated Statistics Management | Teradata Vantage - Automated Statistics Management - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-10-04
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

You have the choice of managing statistics collection manually or allowing Vantage to do it for you. To configure the Teradata system to automatically manage the statistics for one or more databases, the following steps are recommended:

  1. Use the Teradata Viewpoint Stats Manager portlet to identify the databases and tables whose statistics should be automated. Alternatively, directly call the Automate-related APIs available in the TDStats database.
  2. Use the Teradata Viewpoint Stats Manager portlet to define jobs that collect the statistics identified in step 1. Consider defining Analyze jobs to identify additional statistics beneficial to query optimization. Alternatively, directly call Collect and Analyze-related APIs in the TDSTATS database.
  3. If you defined Analyze jobs in step 2, enable the STATSUSAGE logging option via the BEGIN QUERY LOGGING statement for users or applications that access the objects identified in step 1.
  4. Schedule the Collect and Analyze jobs defined in step 2 using either the Teradata Viewpoint Stats Manager portlet or a different scheduling tool (for example, Cron).

For more information, see Teradata Vantageā„¢ - Application Programming Reference, B035-1090, Viewpoint documentation, and the Teradata Orange Book for Automated Statistics Management, 541-0009628.