Ask your System Administrator to run the Manage Collection Element Indexes process if you want to enable faster searches on user-defined collection element values across one or multiple collection plans. This process creates a function-based index that determines which database column in each collection plan contains a particular user-defined collection element. The following search windows and pages use the indexes to quickly find collection element values:
View Quality Results
Update Quality Results
Criteria engine for charts
Criteria engine for reports
Criteria engine for exports
Quality Workbench advanced search
Note: The above search windows and pages can find collection element values even if you do not run this process, but the search time decreases when the search windows and pages use function-based indexes.
In most cases, you only need to run this process once for each of the user-defined collection elements that you intend to search on often. If the system detects a need to regenerate an existing index when you add a collection element, a message appears, informing you to ask the System Administrator to run the Manage Collection Element Indexes process.
In the Submit Requests window, enter Manage Collection Element Indexes in the Name field.
Choose one of the following options:
| Create or Regenerate | Create or regenerate the user-defined collection element index. |
| Drop | Delete the user-defined collection element index. |
Enter an index name. This becomes the name of the user-defined collection element index in the database.
Choose a user-defined collection element from the list of values.
Optional. Enter SQL command words to append to the index create, regenerate, or drop command.