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.
  • Jeff Garmon
  • Nov 9 2015
  • Attach files
  • +3