Date-partitioned indexes have an associated range of date values for the partition property of the objects indexed. For example, the associated date range for an index might be a two month period such as 1 January 2010 to 1 March 2010. The date range is defined by the Start Date and End Date properties of the index. The indexed objects have a partition property value greater than or equal to the Start Date value and less than the End Date value.
An object store has two date partition-related properties:
Date partition property | The date partition property is the name of a property that takes a date/time value. For example, suppose you want to partition documents that belong to an email class based on the received date. You might set the date partition property to DateReceived. |
---|---|
Date partition interval | The interval is the length of time in months of the associated date range of the date partitioned indexes. The possible interval values are 1, 2, 3, 4, 6, 12, 60, or 120. (The default value of null or a value of 0 indicates that partitioning is disabled). |
Based on the data partition interval, the first object indexed for an index determines the date range for the index. For example, suppose that the first object indexed has a partition property value of 10 December 2008 and the partition interval is three months. The Start Date and End Date values are set to 1 October 2008 and 1 January 2009, respectively.
The associated date range for an index as defined by the start and end dates of the index has these attributes:
The following table shows the possible date ranges for a calendar year:
Interval value | Index date ranges |
---|---|
1 | 12 ranges possible:
|
2 | Six ranges possible:
|
3 | Four ranges possible:
|
4 | Three ranges possible:
|
6 | Two ranges possible:
|
12 | One range possible:
|