Press "Enter" to skip to content

Missing Index Recommendations in SQL Server

Andy Brownsword reviews the list:

When running queries, reviewing execution plans, or diving into Query Store it’s not uncommon to see missing index recommendations, particularly for more complex queries. But are they any good?

The answer is yes, but also no. Read on to learn how it is useful, but only if you take into account the foibles of the missing indexes dynamic management view.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.