Question

3
Replies
80
Views
yeungsprite Member since 2018 3 posts
CIBC
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

Declare Index against history table?

There is a request to be able to have a unique task name filter against the history table. As the history table is the largest data table in the application, it is not performant to have a query against the history table for unique task name entries to populate a data page.

An alternative solution is to have a Declare Index that tracks the unique task names. However, there is the following warning:

Note: As a best practice, do not create declarative indexes for top-level Single Value properties.

Is there any negative to using this alternate, or any other suggestion options? A 3rd solution is to manually keep a list of task names, but that requires manual effort to maintain.

Thanks,

Andrew

Moderation Team has archived post
Share this page LinkedIn