How to Quickly Tell if an Execution Plan has Multiple Missing Index Requests
Ever see those little green messages at the top of an execution plan?
Those are missing index suggestions.
SQL Server loves to suggest that you consider changing up your index game.