To optimize the performance of those queries that search
a class property, create an index for the property in the object store
database.
About this task
Restriction: If case-insensitive search behavior is in effect, do not use the
administration console to create the index for DB2® for Linux, UNIX and Windows earlier
than version
10.5.
Procedure
To create an index for a class property:
- Access the table definitions in the administration console:
- In the domain navigation pane, click the object store.
- In the object store navigation pane, click .
- Select the document class.
- Select the Actions tab and click Open Table
Definition.
- Select the Indexes tab and click Add.
- Enter the information for the index that you want to create and click
Save.