Configuring index partitions

Group objects in separate indexes based on the value of an object property to potentially improve full-text search performance. A property used in this fashion is called a partition property. One string property and one date property can be set as partition properties for an object store. Potential search performance gains apply only to those queries that reference a partition property in the WHERE clause of the query SQL statement.

To specify the index partitions for an object store:

  1. In the Enterprise Manager navigation pane, right-click the object store node and click Properties.
  2. Click the CBR IBM Search tab.
  3. If you want to partition indexes based on a String property value, enter the name for the String Property property.
  4. If you want to partition indexes based on a Date property value, enter the name for the Date Property property. Also specify the number of months for the Interval property to determine the range of dates for the indexed objects in an index.
  5. Click Apply to save the changes.
  6. Click Ok to continue if the Reindexing required message is shown.

Next: Reindexing a class. As indicated by the Reindexing required message, you must reindex the CBR-enabled classes to implement changes to the index partition settings.

Related reference
For information about using a partition property in a query, see CBR query syntax introduction.

Related concepts
For information about index partitions, and restrictions on the properties that can be partition properties, see Index partitions.