Missing Index Advisor

The Missing Index Advisor analyzes the details on the missing index and offers you suggestions on different indexes that could be added in order to cover the missing index.

Beware:  Just because an index is missing doesn’t mean that adding the suggested index is the best idea.  Be sure to understand why the index is being added, and if possible track down the query that needs the missing index.  Sometimes it is better to clean up a query instead of just adding a missing index.  Also, before adding any index to a production server, you should test to confirm that the suggested index will get used.

You get to the Missing Index Advisor from the Missing Indexes Report.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

3 Comments on “Missing Index Advisor

Leave a Reply

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

*

To prove you are not a robot: *