Is it possible to add a different partitioning on top of Data Aging?

Thursday, July 12th, 2018

It is possible to add a partitioning on top of Data Aging/after having introduced Data Aging. However, the preferred way is to start the other way round, in order to not move around massive amounts of aged data again.

Start with Hash (or Range) on first level, then add the time selection partitioning using the quick-partitioning possibility. Think upfront about the right partition size, as the second level partitioning will split the data further.