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.
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 :)
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x670
plan explorer upload x480
clustered index scan x6
asked: May 22, 2015 at 10:53 PM
Seen: 695 times
Last Updated: May 23, 2015 at 09:29 AM
Wrong index scan
what indexes to apply/drop
Help with removing the sort form the plan
possible to get MAX() with only an index scan?
this query is taking too long, any ideas how to improve performance with indexes
SQL Server execution plan is using PK instead of index
Why is the index not seeking?
indexing problem after implicit conversion in sql server 2005
index scan vs index seek, how it determine the cost
SQL is ignoring my index hint and using a clustered index.
© 2013 SQL Sentry, Inc. All rights reserved.