From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

View execution plans

View execution plans - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial Buy for my team

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…

Contents