Главная
Study mode:
on
1
Introduction
2
Performance
3
Execution Plans
4
How do we find our plans
5
What is a plan
6
What is an actual plan
7
Demo
8
Estimated
9
Execution Plan
10
Stored Procedure
11
Viewing Execution Plans
12
Live Query Statistics
13
Change Scope Configuration
14
Query Plan Stats
15
Reading Execution Plans
16
Scans
17
Cost
18
Operators
19
Data Access
20
Joins
21
Donut Example
22
Nested Loop
23
Hash Join
Description:
Explore the intricacies of SQL Server execution plans in this comprehensive conference talk from PASS Data Community Summit. Delve into the reasons behind query performance issues and learn how to interpret execution plans to optimize your database queries. Discover techniques for capturing and analyzing execution plans, understanding object access patterns, and identifying basic operations within plans. Through numerous demonstrations, gain practical insights into recognizing potential problems and extracting valuable information from execution plans. Master the skills to effectively troubleshoot and improve query performance, enabling you to tackle slow-running queries with confidence. Leave equipped with immediately applicable knowledge to analyze and optimize SQL queries back at your workstation.

Understanding Execution Plans

PASS Data Community Summit
Add to list