Description |
*Issue* :
There are missing indexes in tables *tblCTSequenceUsageHistory* and *tblCTSequenceHistory* which could improve the performance of grain settlements when added.
The query below in uspCTLogSummary is currently taking around 2~2.5 seconds to finish.
Note: The execution plan below was captured in QC3 using 20.1ZeelandProd (build 20.19.0719.123)
See [query in uspCTLogSummary.sqlplan|http://jira.irelyserver.com/secure/attachment/78951/query+in+uspCTLogSummary.sqlplan]
!pastedImage_d166570_0.png|height=253,width=1890!
*Acceptance* :
Inserting records to @cboLogTemp in uspCTLogSummary should take less than a second.
|