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

castor 2016-07-29 10:00:07

Aaron Bertrand 2016-08-02 16:04:56
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…