2. Run First Purge

Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Example Purge Sequence › 2. Run First Purge

2. Run First Purge

When the first purge runs, the Week 1 partition is purged and the Week 5 partition added. Strategy A specifies a historic partition to retain the permanent records from the Week 1 partition; Strategy B simply retains these permanent records in their original partition. At this stage, there is no practical difference between strategies A and B.

	Strategy A			Strategy B
Partition	Total	Permanent	Partition	Total	Permanent
Week 5	0	0	Week 5	0	0
Week 4	23,000	300	Week 4	23,000	300
Week 3	25,000	400	Week 3	25,000	400
Week 2	24,000	300	Week 2	24,000	300
Historic	500	500	Week 1	500	500