MEAPSA

Describe SQL Server query plans

Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated.

Database Administrator

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Generate and save execution plans
Compare the different types of execution plans
Understand how and why query plans are generated

Units

Introduction min
Describe types of query plans min
Explain estimated and actual query plans min
Identify problematic query plans min
Exercise: Identify issues with a database design min
Knowledge check min
Summary min

Prerequisites

Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Basic understanding of structure and usage of SQL Server indexes.
Basic understanding of relational database concepts.