From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
View a SQL Server execution plan
From the course: Database Foundations: Database Management
View a SQL Server execution plan
- [Instructor] Different relational database management systems will have different capabilities when it comes to displaying information about query plans. And each RDBMS will decide on different plans by the internal optimizers even when given the exact same query on the exact same data. So, specific performance tuning strategies are highly variable. It'll be unique for every database and platform. But most platforms will allow you to review the query plan so that you can see what's happening behind the scenes and how your queries progress from the written command to the final result. I want to take a look first at how query plan information is exposed in SQL server. And then we can compare to how PostgreSQL displays the same plan information. I currently have the text from the ExecutionPlan-Start file here in a new query window that's connected to my SQL server database. To get here, just right click on the databases name and your connection sidebar, choose new query and then paste…
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.