When to Collect Statistics | Teradata Vantage - 17.00 - 17.05 - When To Collect Statistics - 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

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.