From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Identify and implement index changes for queries

Identify and implement index changes for queries

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Identify and implement index changes for queries

“

- Welcome back. This is lesson 8.5. Identify and implement index changes for queries. Indexes are critical to overall performance of SQL and regular index and query analysis should be at the top of every SQL administrator's list. As part of that analysis is reviewing index usage and identifying unused or missing indexes. So let's review those. Let's start with missing indexes. As part of executing a query and a query window in SSMS, you can select to view the execution plan. The SQL server engine will generate a query plan during query execution, and as part of that, will look at indexes that it can use to generate an optimal plan. It will also recommend additional indexes if it determines that adding an index will help improve query performance. So in the last video, we discussed several dynamic management views to help in identifying performance issues. One of these that we discussed was sys.dm_db_missing_index_details. And this DMV returns information about indexes that the query…

Contents