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
trueRebalancer Assignment Policy set to
queryLocking set to
strictIndexes established for the elements or properties to be queried
Query partitions, as described in Creating Query Partitions
Note
Unlike range partitions, it is not necessary for all of the forests in a database configured for tiered storage to be part of a query partition.
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:
Click Databases in the left tree menu. A list of databases appears.
Click your target database.
On the configuration tab for the database, set the Assignment Policy to query. The Default Partition field appears.
[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.