17.00 - Example: Heavily Modified Table - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1186-170K
  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%