From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
View execution plans - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
View execution plans
- [Instructor] Viewing a query's execution plan can give you some good insights into the performance of your database. Execution plans display all of the actual steps that SQL Server moves through when retrieving and sorting through the records in your database during the processing of a select query or a SQL script. Let me show you what these look like by viewing the execution plan of a query against our reservation details view. I'm going to start a new query window here, and we're simply going to type in select star from reservation details. Remember that this reservation details view is collecting and joining data from three different data tables in the Landon Hotel database. To display the estimated execution plan, we can take a look at this button here on the toolbar, and if you click it, you'll see this execution plan appear at the bottom of the screen. This displays all of the steps that SQL Server plans on moving through to return the answer to our query. Another way that we…
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.