Difficulty finding covering index for this

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.

avatar image By RandyH 0 asked May 22, 2015 at 10:53 PM
more ▼
(comments are locked)
avatar image SQLkiwi ♦ May 23, 2015 at 09:29 AM

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 :)

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x27
x6

asked: May 22, 2015 at 10:53 PM

Seen: 600 times

Last Updated: May 23, 2015 at 09:29 AM