Index partitioning by date range

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 January 1, 2010 to March 1, 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.

Date partition-related properties

An object store has two date partition-related properties:

Relationship between partition interval and index date ranges

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 December 10th, 2008, and the partition interval is three months. The Start Date and End Date values are set to October 1, 2008 and January 1, 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:
  • January 1 to February 1
  • February 1 to March 1
  • And so on.
2 Six ranges possible:
  • January 1 to March 1
  • March 1 to May 1
  • May 1 to July 1
  • July to September 1
  • September 1 to November 1
  • November 1 to January 1 of the following year
3 Four ranges possible:
  • January 1 to April 1
  • April 1 to July 1
  • July 1 to October 1
  • October 1 to January 1 of the following year
4 Three ranges possible:
  • January 1 to May 1
  • May 1 to September 1
  • September 1 to January 1 of the following year
6 Two ranges possible:
  • January 1 to July 1
  • July 1 to January 1 of the following year
12 One range possible:
  • January 1 to January 1 of the following year