Example: Heavily Modified Table - Advanced SQL Engine - Teradata Database

ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kit1592007446534.ditamap
dita:ditavalPath
kit1592007446534.ditaval
dita:id
B035-1186
lifecycle
previous
Product Category
Teradata Vantageā„¢
  System-time Table Bitemporal Table
Table Size Before Modifications (rows) 100 100
Modification Type Current FOR PORTION OF
Modifications per Year (percent of rows) 50% (0.96% weekly) 50% (0.96% weekly)
Number of Additional Rows Produced per Modification 1 1, 2, or 3
Largest Table Size After Modifications (rows) 150 250
Annual Increase in Table Size 50% 150%