vendredi 30 janvier 2015

Best practices for selecting partition boundary ranges to maintain empty partitions at both end?


I have partitioned the table based on a date datatype partitioning column.


The data for the column starts at "2014-01-01" and ends at "2015-01-01". I know that, the partitions should have empty partitions at left and right ends. So, I selected the following boundary ranges while creating the partition function. The partition function is shown below,



create partition function PfDateRange(date)
as range right for values('2014-04-01','2014-07-01','2014-10-01','2015-01-01')


I would like to hear some tips or good practices for selecting boundary ranges.


Also, at future the data may get inserted which were greater than the last boundary range. So how to maintain empty partition at the right end?


Thanks in advance.





Aucun commentaire:

Enregistrer un commentaire