Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Understanding Execution Plans

PASS Data Community Summit via YouTube

Start learning Write review
Corporate Finance Institute Ad

Finance Certifications Goldman Sachs and Amazon Teams Trust

Learn More → Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session uses demonstrations to show how to capture and read SQL Server execution plans, identify accessed objects and basic operations, and spot potential query performance problems.

Syllabus

Introduction
Performance
Execution Plans
How do we find our plans
What is a plan
What is an actual plan
Demo
Estimated
Execution Plan
Stored Procedure
Viewing Execution Plans
Live Query Statistics
Change Scope Configuration
Query Plan Stats
Reading Execution Plans
Scans
Cost
Operators
Data Access
Joins
Donut Example
Nested Loop
Hash Join

Taught by

PASS Data Community Summit

Reviews

Start your review of Understanding Execution Plans

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.