Change dbo.spREINT_GetEmailRecipientsInfo to perform better
dbo.spREINT_GetEmailRecipientsInfo should be changed so it does not do a full indexscan on [dbo].[EmailJob_Recipient].[IX_EmailJob_Recipient_UpdateDate_ID_EmailID_BackOfficeSystemPeopleID_UserID]. This process runs every X minutes (per configuration) and I suggest it should be changed to not have to scan all x million rows every time it runs.
Not sure why support sent me to ideabank for a reported performance issue, but if needed, reference support case 12489390 for specific details.