From the course: SQL Server Performance for Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Missing index warnings

Missing index warnings - SQL Server Tutorial

From the course: SQL Server Performance for Developers

Start my 1-month free trial

Missing index warnings

“

- [Instructor] Let's talk about missing index warnings. This is something that SQL Server Optimizer gives us and includes in execution plans and can be a real benefit to helping you tune queries. However, there are some limitation to what SQL Server gives us in terms of missing indexes and there are some behavior that you should be aware of, and you should, as always, take any index advice with a grain of salt, it's definitely more of an art than a science, and later in the course you'll see a chapter that's dedicated to indexes and we'll focus on indexes in detail. SQL Server will give you missing index warnings as part of your execution plan if the optimizer determines that you should index a certain set of columns in order to give you better performance for a query. It does not, however, correlate that information with anything else, so a missing index warning is simply for a given query. You can get recommendations for overlapping indexes, which can be problematic. This is…

Contents