Creating database indexes for class properties (Oracle)

To optimize the performance of those queries that search a class property, create an index for the property in the object store database. The index that you create is a specific type of function-based index in the following circumstances: case-insensitive search behavior is in effect, and the object store database is an Oracle database.

To create a function-based index for a class property:

1. Connect to the object store database by using the appropriate Oracle database tool.
2. Run a command with the following syntax:

   Command syntax	CREATE INDEX idx_name ON table_name(LOWER(column_name));
   Example	CREATE INDEX lc_lname ON DocVersion(LOWER(lname));

   table_name

   The table that contains the column: DocVersion for documents, Generic for custom objects, and Container for folders.

   column_name

   The name of the property column.

   idx_name

   The name of the index.