Have you considered a filtered index on ActivityNote (WHERE IsDeleted = 0)? It seems like currently your index has IsDeleted as the leading key column. It might be better to make that filtered...
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 x641
plan explorer pro upload x166
sql server x19
asked: Jul 29, 2016 at 10:00 AM
Seen: 341 times
Last Updated: Aug 02, 2016 at 04:04 PM
What performance improvements can be done on this
Index not being used
Any advice on this query
Any idees how to get better performance for this query, it's a vendor app I cant change the query just indexes, statistics and plan guide.
Am I missing anything obvious while tuning this query ?
Do I need an index for a table that is used by a trigger and monitor?
What kind of questions can I ask here, and how does the site work?
Running a query twice, the second one has less IO/cost?
What could cause this query to increase the execution time from 10 seconds to 2h30?
© 2013 SQL Sentry, Inc. All rights reserved.