Indexing Database Fields

When database fields are created for folder and document types, it is possible to also create an index on the field with the SQL Server database engine. Indexing database fields will improve the performance of the system when performing searches that include those particular fields. However, it may also cause the database to grow in size at a faster rate, which could potentially decrease the performance of the system when new records are added to Digital Storage Manager. In general, database fields should only be indexed if they will be regularly used for searching purposes.

Indexing database fields of a folder/document type

1. Select Forms and Finds from the Administration menu. This will open the Forms and Finds window if it is not open, or bring it to the front if it is already open.
2. Select the folder type (Digital Resources or Retrieval Requests) whose database fields you want to view for indexing purposes.
3. ‘Check’ the checkbox in the Index column ( ) for each database field of the selected folder type that you want to be indexed. Placing a ‘check’ will instruct the SQL Server database engine to create an index for the database field. Indexes will not be created for database fields for which the Index column is left blank.

Note: Indexes cannot be created for file collection and memo database fields, nor can the index setting for system defined fields be changed.

1. Click Save ( ). This will create the indexes you have specified in the Digital Storage Manager database.