Cool. In that case the business rules for how, when and by what criteria rows are archived will guide your choice of partition column.

Thank you.

I want to create 3 partitions Based on the List of region (RegionGroup1Current,RegionGroup2Current,RegionGroupCurrent) and Other 3 for one month old data (RegionGroup1Old,RegionGroup2Current,RegionGroupOld)

Here am looking to keep current data in first 3 partitions and after one month need to move into other 3 partitions based on the date.

Here i need to consider region and date.

Thanks in advance