Should Aging partitions be on first level or on second level?

Thursday, July 12th, 2018

Data Aging Partitioning can be done on first level without any second level or used as a second-level below a hash- or range-partition. If there is any risk that the remaining amount of records in “current” partition after Data Aging can approach the two billion records limit in the future, choose a two-level approach with aging being the second level.

Take future volume growth into consideration as well as residence times for Data Aging.