Cool. In that case the business rules for how, when and by what criteria rows are archived will guide your choice of partition column.
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