When to Collect Statistics | Teradata Vantage - When To Collect Statistics - 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
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

Collect statistics at the following phases of table development:

  • Newly created, unpopulated tables.

    Collect statistics on unpopulated tables to set up the interval histogram used in internal processing. This initial collection makes subsequent statistics collections faster. Make sure to recollect statistics after data is added.

  • Prototype phase, newly populated tables.
  • Production phase, after a significant percentage of change to the table or partition (~10% rows). For high volumes of very nonunique values, such as dates or timestamps, it may be advantageous to recollect at 7%.

    Recommendation: Collect production phase statistics after you have created users and applied real world query loads to the database (up to about 3 months of querying).

  • Collect statistics in the first few weeks after an upgrade or migration during periods of low CPU utilization.