How can I reduce the overhead of the Index Seek cost on the Non-Clustered Index

tmp37A5.pesession (45.3 kB)
avatar image By castor 0 asked Jul 29, 2016 at 10:00 AM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Aug 02, 2016 at 04:04 PM

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...

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
x166
x27
x19
x2

asked: Jul 29, 2016 at 10:00 AM

Seen: 341 times

Last Updated: Aug 02, 2016 at 04:04 PM