Creating database indexes for class properties (Oracle)

Use this procedure only if you do not want to use Administration Console for Content Platform Engine to create the index. 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.