Examples | Capacity Planning for Temporal Tables | Teradata Vantage - Example: Lightly Modified Table - Advanced SQL Engine - Teradata Database

ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ngt1556732962433.ditamap
dita:ditavalPath
lze1555437562152.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 (open rows) FOR PORTION OF
Modifications per Year (percent of rows) 10% (0.19% weekly) 10% (0.19% weekly)
Number of Additional Rows Produced per Modification 1 1, 2, or 3
Largest Table Size After Modifications (rows) 110 130
Annual Increase in Table Size 10% 30%