From the course: Microsoft SQL Server 2016: Query Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introducing query execution plans - SQL Server Tutorial
From the course: Microsoft SQL Server 2016: Query Data
Introducing query execution plans
- [Instructor] In this lesson we'll introduce query execution plans. In a previous lesson on understanding the processing stages, we discussed how the database engine processes the queries that you write, and we know that it does so in a logical order which is slightly different from the way you've written the query. But outside of the query engine doing syntax checking and resolving all of your table and object names for the database, the database engine will actually attempt to optimize that query based on what it sees in the table. It helps if we have different indexes, such as clustered or non-clustered indexes created on the tables. But what we're going to do is take a look at, really, what SQL Server sees in terms of how it will execute your queries, and this might help you understand maybe how you can optimize your own queries or how SQL Server might look at making some optimizations as well. So our query execution plans will provide that insight into how the database engine…
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.