Indexes - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265
Note: This tab is only available for internal database data stores.

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.