6

I recently watched the sp_Blitzindex video and testing the tool found most of our tables had a combination of missing indexes and also indexes which have hundreds of writes and no reads. I think that means we should remove those with no reads.

Anyway we removed the first one and then ran the sp_Blitzindex againand the missing index wasn't shown.

Does this mean removing the not needed index resets the cache? Should we do it the otehr way around? Add the missing first, then delete the redundant indexes?

Attached screenshots to illustrate what happened.

sp_Blitzindex before and after removing index

1 Answer 1

8

When you make index changes to a table, SQL Server resets the missing index suggestions for that table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.