From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Identify and create missing indexes - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Identify and create missing indexes
- [Instructor] SQL Server ships with an external tool called the Database Engine Tuning Advisor that will evaluate a single query or a batch of SQL code and suggest areas where the database's performance might be improved. Let's take a look at it by evaluating this query in the WideWorldImporters database that pulls out a couple of columns: the PurchaseOrderID, PurchaseOrderLineID, StockItemName, and ColorName from a series of tables. We're going to filter all of these records and only show the products where the ColorName is equal to black. So let's suppose that this query architecture is one that we run often. And we want to make sure that we have the indexes created that will give the most benefit to the execution plan. To do this, we'll leverage the Database Engine Tuning Advisor. Now, in SQL Server Management Studio 17, you can get to the Tuning Advisor from the Tools menu and choosing Database Engine Tuning Advisor. In prior versions, you had to open it as a separate application…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.