From the course: Microsoft SQL Server 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Explore execution plans - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Explore execution plans
- [Instructor] In this section, we're going to talk about execution plans. And for this I'd like to go back and query my index test table in the demo database, so I'll hit new query. And I'll use the same query we worked with earlier. I don't need the rapper to give me the statistical information and I don't need the lines at the top to clear the buffer, I just want the query. Notice I'm getting the little red squiggly line under several of these items. This is because the Intellisense hasn't yet picked up that that's a valid table and valid column names. If you get this, you can refresh the Intellisense by pressing Control Shift R, and once I do that, the red squiggly line goes away, excellent. Now before I run this query, I'm going to click on one of the buttons on the toolbar. It's a little hard to describe. It looks like some blue squares and one green square with arrows pointing between the squares. When you hover over it, it says include actual execution plan. So I'll click on…
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.