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