From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 2 Azure Data Optimization and Automation
Join today to access over 24,700 courses taught by industry experts.
Estimated and actual query plans
From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 2 Azure Data Optimization and Automation
Estimated and actual query plans
- [Instructor] When it comes to optimizing performance, the most important skill you can have as a database administrator is the ability to read and understand query execution plans. There are lots of ways that the database engine can go about retrieving the data requested by a query. Before any query is executed in a SQL server database, information about indexes and statistics are used to generate possible ways to obtain the requested information. These different approaches are then evaluated based on their expected costs in terms of system resource consumption. And the cheapest plan is selected and executed. All of this cost estimation is based on the system's best guess about how the process is going to proceed. And you can imagine that accurate estimates about resource consumption depend on the availability of accurate statistical and index information. The entire process is very similar to choosing a route through a city. There are any number of streets that you can go down to…
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.