Update an Index

This window allows you to update a multiple field index.

Select the Cluster check box if you want to set this index as a cluster index. A cluster index is maintained or improved dynamically as data is inserted into the associated table by attempting to insert new rows physically close to the rows for which the key values of the index are in the same range. This process might slow down the loading of database rows, but should improve the performance of retrievals (queries from a client). This option cannot be applied to existing tables. Deselect the Cluster check box if you do not want to set this index as a cluster index.
Note:
  • The Cluster checkbox is not available if the server is a Content Manager OnDemand for i server.
  • If any selected field of a multiple field index has Document Size, Page Count, or Records Management attributes, you cannot set the index as a cluster index, and the Cluster checkbox is disabled.
  • If a multiple field index has already been added as a cluster index, the Cluster checkbox is disabled.

To select a database field, highlight the field, and click Add. The database field should be displayed under Selected Fields.

To remove a database field from the Selected Fields section, highlight the field, and click Remove.

You can select up to 16 fields in one multiple field index. If you attempt to add more than 16 fields, you receive an error.

All selected fields are listed in ascending order by default. To change the order for the fields, select a field from the list, and select Descending or Ascending.

Click Move Up or Move Down to move the selected field up and down in the list.

Click OK to confirm your changes. Click Cancel to discard your changes and close the window.