Indexing can greatly reduce database search time.
Indexes can be defined for data fields on regular forms. You cannot create indexes for other form types because:
- Join forms use the indexing defined for the forms from which they are constructed.
- Display-only forms have no database table, so they need no indexing.
- View and vendor forms are owned outside of BMC Remedy AR System, so any indexing they support must be managed outside of BMC Remedy AR System.
The Request ID field is already indexed, so you need not build a separate index for this field. Good candidates for indexing include fields that users search on frequently.
If you define an index for a character field, you might save search time by using a QBE Match setting of Leading or Equal, not by using a QBE Match setting of Anywhere. For more information, see the description of the "QBE Match" property under the Field Properties table.
If you are creating or modifying indexes in a form for which a large amount of data exists, this process can take a significant amount of time and disk space because the index must be built or rebuilt. Therefore, avoid defining indexes during normal production hours.
More time is required to modify a form (for example, adding new fields) when indexes are defined for the form. The greater the number of indexes defined for the form, the more time and disk space is required. Submit and modify operations in a browser also take longer on forms with many indexes.
To define indexes for a form
- Open the form with which you want to work.
- Click the Definitions tab, and expand the Indexes panel.
- Add a new index to the list:
- Select Additive as the Overlay Type, then click New.
- Select the new index.
- To add fields to the index, click Add and complete the Field Selector dialog box for each field.
You can combine multiple fields into a composite index. You can enter as many as 16 fields. Add the fields in the order you want them indexed, or use the Up and Down buttons to put them in the correct order. Each indexed field must be less than or equal to 255 characters, but the composite Index can have a total length greater than 255.
Use the Remove and Remove All buttons to remove fields form the index.
BMC Remedy AR System does not verify if the size violates the databases rules, but a database error is returned if the size is too large.
- To remove an index from the database, select the index, and click Delete.
- Save the form.