SQL Server Notes by AB | Note #18 | Multiple Missing Index Hints | #ABSQLNotes

SQL Server Notes by AB?| Note #18 | Multiple Missing Index Hints | #ABSQLNotes

Did you know that you can get multiple missing index hints in your execution plan? When you switch over to the execution plan tab, you can see one missing index hint on the top (in green color). When you right-click the hint -> Missing Index Details, you get the index definition script in a new query window. Most would think that that is the only missing index hint for your query. In reality, there could be multiple missing index hints at the same time for your given query/plan. To see all the missing index hints, right-click the SELECT operator, click Properties, scroll down to the Missing Index section in the properties window, and expand all the missing index hints. Not very intuitive, but still helpful. Demo URL: https://www.youtube.com/watch?v=wyJEt8IXEGM. Want to read more SQL notes like this one? Here: https://bit.ly/ABSQLNotes