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 x691
plan explorer upload x502
clustered index scan x6
asked: May 22, 2015 at 10:53 PM
Seen: 727 times
Last Updated: May 23, 2015 at 09:29 AM
Wrong index scan
Help with removing the sort form the plan
possible to get MAX() with only an index scan?
what indexes to apply/drop
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
SQL is ignoring my index hint and using a clustered index.
Index Analysis never completes
© 2013 SQL Sentry, Inc. All rights reserved.