Use the Query Store to Identify Missing Indexes

First published at 15:56 UTC on April 3rd, 2019.
subscribers

SQL Server has a system of dynamic management views (DMV) that let you see the suggested missing indexes. However, those are not tied in any way to a query. You can use the Query Store to get the missing index information and tie it to a query. This…

MORE
CategoryScience & Technology
SensitivityNormal - Content that is suitable for ages 16 and over
DISCUSS THIS VIDEO