SQL Scripts: How To Find Missing Indexes (Posted on June 5, 2018 by Eric Cobb)
One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it is used, or if it is even being used at all. But SQL Server doesn’t just monitor the indexes that you currently have, it even keeps up with statistics for indexes that it wishes you had!
What Are Missing Indexes?
When SQL Server is processing a query, it will sometimes make a suggestion for an index that it believes will help that query run faster. These are known as Missing Indexes, or as I like to refer to them, Missing Index Suggestions. The reason that I stress “suggestions” is that while SQL Server is very good at determining when an index is needed, it sometimes isn’t so good at recommending what that index should be. http://www.sqlnuggets.com...ind-missing-indexes/