Question

3
Replies
102
Views
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
Posted: 21 Aug 2018 14:34 EDT
Last activity: 23 Aug 2018 4:09 EDT
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.

Show More

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

Show Less
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.