3. Run Second Purge

Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Example Purge Sequence › 3. Run Second Purge

3. Run Second Purge

When the second purge runs, the Week 2 partition is purged and the Week 6 partition added. Under strategy A, the historic partition now contains permanent records from both the Week 1 and Week 2 partition; Strategy B simply retains these permanent records in their respective original partitions.

	Strategy A			Strategy B
Partition	Total	Permanent	Partition	Total	Permanent
Week 6	0	0	Week 6	0	0
Week 5	26,000	200	Week 5	26,000	200
Week 4	23,000	300	Week 4	23,000	300
Week 3	25,000	400	Week 3	25,000	400
Historic	800	800	Week 2	300	300
			week 1	500	500