Actions
Bug #6972
closedActivity index not being used
Description
The index for activity table is not being used. This is causing queries to be A LOT slower than expected. Review fixing the indexes to allow for better performance.
Actions
Added by krileon almost 8 years ago. Updated almost 8 years ago.
Description
The index for activity table is not being used. This is causing queries to be A LOT slower than expected. Review fixing the indexes to allow for better performance.
Asset column was not necessary in the index. 2 indexes are also needed to cover pinned and non-pinned usage cases.