Configuring a Database with Query Partitions

If a database is to participate in a tiered storage scheme using query partitions, it must have these settings:

• Rebalancer enable set to true

• Rebalancer Assignment Policy set to query

• Locking set to strict

• Indexes established for the elements or properties to be queried

• Query partitions, as described in Creating Query Partitions

For details on the database rebalancer with the query assignment policy, see the sections Query Assignment Policy, Configuring the Rebalancer on a Database, and Configuring the Rebalancer on a Forest.

To configure a database to use the query assignment policy, follow these steps:

1. In the Admin Interface, open the configuration page for the database, and set the assignment policy to query. The default partition setting appears under the assignment policy.

2. [OPTIONAL] Enter the partition number for a default query partition in the Default Partition field. If you do not define a default query partition, then your database must have forests that are not part of a query partition. These forests will serve the same role as a default partition.