17.00 - Example: Moderately 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) 30% (0.58% weekly) 30% (0.58% weekly)
Number of Additional Rows Produced per Modification 1 1, 2, or 3
Largest Table Size After Modifications (rows) 130 190
Annual Increase in Table Size 30% 90%