Difficulty finding covering index for this

RandyH 2015-05-22 22:53:33

80% of the query is stuck on this clustered index scan. covering index didnt seem to help, actually, it seemd to reduce the cpu overhead but make the query run longer.

SQLkiwi 2015-05-23 09:29:33
It's very tough to assess performance problems based on an estimates-only anonymized plan. Provide a post-execution analysis file please, ideally with the query executed directly from Plan Explorer. Even more ideally (!) do not anonymize the plan 🙂