IBM FileNet P8, Version 5.2.1            

Managing index properties

Use the Index Properties window to add or remove fields from your roster, queue, or event log index.

You can also change the order of the indexed fields for composite indexes. A composite index (also called a concatenated index) is an index that you create on multiple columns in a table. Columns in a composite index can appear in any order.

Composite indexes can speed retrieval of data for search filters in which the filter conditions reference all or the leading portion of the columns in the composite index. Therefore, the order of the columns used in the definition is important; generally, the most commonly accessed or most selective columns go first.

  1. From the Index Properties window, add, remove, or change the order of the fields as needed.
  2. Click OK when done.
Important: An index must not exceed the maximum allowable size.


Last updated: October 2015
bpfc060.htm

© Copyright IBM Corporation 2015.