If the search functionality provided in a data store's search screen(s) is found to be slow, you can attempt to improve it by creating an index. Index creation simply involves selecting a field from the data store that is used to perform searches.
To gauge whether the index has improved the data store's search, you should then attempt to search for records using the same field that was used to create the index.
Automatically generated indexes
Once an internal database data store is associated to a case store, the following indexes will be automatically created within the data store.
- IDX_OwningSubObjectID
- IDX_OwningSubObjectUID
- IDX_SysDeleted
As with manually created indexes, these indexes are intended to improve search speed when searching the contents of an internal database data store. Within the UI, you can also: change the fields that comprise these indexes, change the order in which the fields that comprise the index are used, and specify whether to sort the fields that comprise the index in ascending of descending order.