This story is created to evaluate if we will work on this performance improvement.
It implies some work in the harmonizer, the lmsx extension, and the view.
We did some tests with different approaches to improve the performance in the mentioned view, here are the findings
Also consider using an index like this. It might not improve anything - just worth trying. Might need to add an Include clause with the other columns that are in the view output.
create index IX_AssignmentDim_GradingPeriod on [lmsx].[Assignment] (
AssignmentCategoryDescriptorId,
GradingPeriodId,
LMSSourceSystemDescriptorId
)
This story is created to evaluate if we will work on this performance improvement.
It implies some work in the harmonizer, the lmsx extension, and the view.
We did some tests with different approaches to improve the performance in the mentioned view, here are the findings
Also consider using an index like this. It might not improve anything - just worth trying. Might need to add an Include clause with the other columns that are in the view output.