Question

3
Replies
90
Views
Close popover
Andrew Yeung (yeungsprite)
CIBC
Certified Lead System Architect
CIBC
CA
yeungsprite Member since 2018 3 posts
CIBC
Posted: August 21, 2018
Last activity: August 23, 2018
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