Missing index details on the execution plan screen
Hi i am using sql server 2012. i run a query to practice for missing index. i turn on the "Include Execution plan" from the SSMS too, after i run a simple query select lastname from tperson where lastName = 'Duffy' when i clicked on the Execution plan tab, my training video show there is a Missing index message displayed under the query, but I did not see it from my screen. Did i miss anything? really appreciate if you know can advise me. Thank you, Fong
The smaller table is almost certainly the difference. If the table is small enough SQL Server will often scan the whole table rather than using an index or even looking for or recommending one. Throw 100,000 or so more rows in there and see if it recommends an index then (make sure you have a variety of last names, not just 100,000 Duffys.