17.05 - Example: Capacity planning for moderately modified temporal tables - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K
  Transaction-time Table Bitemporal Table Bitemporal Table
Table Size Before Modifications (rows) 100 100 100
Modification Type Current Current Sequenced (historical)
Modifications per Year (percent of rows) 30% (0.58% weekly) 30% (0.58% weekly) 30% (0.58% weekly)
Number of Additional Rows Produced per Modification 1 1 or 2 1, 2, or 3
Largest Table Size After Modifications (rows) 130 160 190
Annual Increase in Table Size 30% 60% 90%