From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Analyze execution plans and tune queries - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Analyze execution plans and tune queries
- [Instructor] We've seen a couple of execution plans while we were investigating various indexing techniques, but it's going to be important to dig in to them a little more and better understand the information that they contain. Execution plans will give an observant database administrator all of the information that they need in determining how a particular query will execute, and all of the steps that SQL Server goes through in order to arrive at the solution. To get started, let's go ahead and jump back into the wide world importers database. Next, I'm going to run this long query here that selects a number of field from a number of different tables, and then filters the invoice lines to only the ones who look for black products. Let's go ahead and highlight these lines, but before I run it, I want to press this button here on the toolbar that says Display Estimated Execution Plan. This will return a quick estimation…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.