Continuation of ticket and implement the following enhancement:
Allow definition of second partition key column for sub-partition of table.
Add IsAttached flag to AD_TablePartition and support detach/attach of partition.
Test Case for sub-partition:
Checked Partition flag for table AD_ChangeLog.
Navigate to column AD_Client_ID, checked Partition Key and select List as the partitioning method. Partition sequence default to 10.
Navigate to column Created, checked Partition Key, select Range as partitioning method and enter 6 month for partition range interval. Partition sequence default to 20.
Run Create/Update Partition process.
Table partition tab will be updated with primary partition created for column AD_Client_ID and sub-partition created for column Created.
Continuation of ticket and implement the following enhancement:
Allow definition of second partition key column for sub-partition of table.
Add IsAttached flag to AD_TablePartition and support detach/attach of partition.
Test Case for sub-partition:
Checked Partition flag for table AD_ChangeLog.
Navigate to column AD_Client_ID, checked Partition Key and select List as the partitioning method. Partition sequence default to 10.
Navigate to column Created, checked Partition Key, select Range as partitioning method and enter 6 month for partition range interval. Partition sequence default to 20.
Run Create/Update Partition process.
Table partition tab will be updated with primary partition created for column AD_Client_ID and sub-partition created for column Created.