Create database indexes for class properties

You can create a database index for any class property except a system-owned property. These database indexes, also known as "single indexes" are stored within the object store database. For properties that your users frequently search, single indexes enable you to reduce the amount of time it takes to process queries on this property. To search database indexes for class properties, use SQL syntax rather than VQL.

NOTE  When a class property is set or unset for single indexing it is automatically set or unset in all subclasses.

To create database indexes for class properties

  1. From the Enterprise Manager tree view, right-click on the class that contains the properties you want to configure for CBR.
  2. Select Properties from the context menu.
  3. Select the Property Definitions tab.
  4. Select the property you want to index and click Edit.
  5. On the Properties dialog, click Set/Remove.
  6. On the Set/Remove Indexing dialog, select the Set option and check Single Indexed.