Understanding Execution Plans and Indexes in SQL Server
Learn Basic to Advanced Level Training of Indexes and Execution Plans using T-SQL Commands in Microsoft SQL Server
Ratings 4.73 / 5.00
What You Will Learn!
- Participants will get deeper knowledge on Clustered ,Non Clustered Indexes & Fragmentation Concepts
- Participants will learn commonly used Execution Plans
- Participants will learn to find the patterns which may be slowing down the query performance
- This course will Help Participant to tune already written query or write T-SQL in a better way
Description
This course is not for beginners. One should have prior knowledge on T-SQL commands before enrolling into this course.The course contains the following topics
Index Concepts in SQL Server
Page in SQL Server
Extent in SQL Server
Heap in SQL Server
Clustered Index
Non Clustered Index
Heap with Non Clustered Index
Indexes are not very Deep
Composite Index
Index Fragmentation
Index Creation using T-SQL Commands
Index Rebuild and ReOrganize
FillFactor
Included Columns
Data Type on Clustered Index
Execution Plan
Statistics
Actual Execution Plan
Estimated Execution Plan
Common Operators
Table Scan
Index Scan
Index Seek
Key Lookup
RowID Lookup
Nested Loop
Sort
Merge Join
Hash Join
Compute Scalar
Stream Aggregate
Hash Aggregate
Left Semi Join
Right Semi Join
Left Anti Semi Join
Right Anti Semi Join
Segment
Sequence Project
Lazy Spool
Eager Spool
Parallelism - Distribute Stream ,Gather Stream & Repartition Stream
More on Execution Plans
Halloween Problem
Execution Plan of Insert Operation
Execution Plan of Delete Operation
Execution Plan of Update Operation
Subtree cost related to Parallelism
Subtree Cost of Stream and Hash Aggregate
Index supports Wild Card
Patterns to Note to Tune Queries
Parameter Sniffing
Parameter Sensitive Plan Optimization in Sql Server 2022
MergeJoin Patterns
Hash Join Patterns
Key Lookup Patterns
Sort Indicators
Aggregate Indicators
Parallelism Indicators
Warnings in Execution Plan
From this course you will learn how to read and understand execution plans which will help in tuning Transact SQL Commands
Who Should Attend!
- The partitcipants who have prior knowledge of T-SQL commands.
- This course is for SQL Server Developers , SQL Server DBAs, .NET Developers who writes T-SQL Commands , Data Analysts etc.