Manage index properties

Use the Index Properties dialog box to add or remove fields from your roster, queue, or event log index. See Manage indexes for additional information.

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.

To add or remove fields in the index

  1. To add fields to the index, select one or more Available items and click Add.

    To remove fields, select one or more Selected items and click Remove.

  2. Click OK when done.

To change the order of the indexed fields

  1. Select one or more Selected items, then click Up or Down .
  2. Click OK when done.

NOTE An index must not exceed the maximum allowable size.