partitioning, history tables (especially temporal tables), and archival via partition detach — are structural decisions that determine whether a system can maintain performance as data grows over years.