Brent Ozar shows what happens when there are multiple missing indexes for a query:
SQL Server Management Studio only shows you the first missing index recommendation in a plan.
Not the best one. Not all of them. Just whichever one happens to show up first.
Using the public Stack Overflow database, I’ll run a simple query:
But that behavior isn’t the case for all tools; SQL Operations Studio is a bit different.