Automated Statistics Management | Teradata Vantage - 17.00 - 17.05 - About Automated Statistics Management - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.