SQL Server: Script to find Missing Indexes

In this post, I provide one script to find missing indexes in SQL Server.
When you execute any SQL query, internally SQL Server also checks for requires indexes and prepare statistics. But still DBA has to take a decision based on query execute planner. SQL Server stores this different stats into three main Dynamic views which is used in below query.

Anvesh Patel

Leave a Reply

7 Comments on "SQL Server: Script to find Missing Indexes"

Notify of
Sort by:   newest | oldest | most voted

Keep on working, great job!


This design is incredible! You most certainly know how to keep a reader entertained.

Between your wit and your videos, I was almost moved to start my own blog (well,
almost…HaHa!) Wonderful job. I really loved what you had to
say, and more than that, how you presented it. Too cool!


This is a topic that’s near to my heart…
Cheers! Exactly where are your contact details though?


Thanks Anvesh !
You helped us lot.
Please keep sharing, You are really doing great job…
Every day writing, what a dedication you have.
I am going to share this blog with my friends.


you helped a lot….
Happy new Year Anvesh….. Looking best for 2017….


thank you for sharing…