Initially all Tables participating in Data Aging have an additional column _DATAAGING, which is the basis for the time selection partitioning. The default value of this column is ‘00000000’. When the time selection (=RANGE) partitioning is performed on this column, all records will remain in the hot partition – no data has to be moved. The cold partitions (=new time RANGEs) will be added empty one by one – again no data has to be moved during partitioning itself.
Only during the Data Aging Run column _DATAAGING is filled and the aged data will be moved from the hot partition to the cold partition(s).
What does quick partitioning mean?
Thursday, July 12th, 2018