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 x676
plan explorer pro upload x166
sql server x23
asked: Jul 29, 2016 at 10:00 AM
Seen: 367 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
What indexes should I add to odsstaging to improve the performance of 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?
© 2013 SQL Sentry, Inc. All rights reserved.