|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/understanding-execution-plans-indexes-sql-server/
课程评论：没有评论
Coursera SQL Server 执行计划与索引解析课程总结 本课程面向具备 T-SQL 基础知识的学习者，深入探讨 SQL Server 中的执行计划和索引。 **核心内容涵盖：** * **索引基础：** 详细讲解 SQL Server 中的页（Page）、区（Extent）、堆（Heap）、聚集索引（Clustered Index）、非聚集索引（Non-Clustered Index）及其组合。 * **索引优化：** 探讨索引深度、复合索引、索引碎片化，以及如何使用 T-SQL 命令创建、重建和重组织索引。 * **索引结构优化：** 讲解 Fill Factor、Included Columns 和数据类型对聚集索引的影响。 * **执行计划解读：** 深入剖析估计执行计划和实际执行计划，识别 Common Operators（如 Table Scan, Index Scan, Index Seek, Key Lookup, RowID Lookup）和 Join Operators（如 Nested Loop, Sort, Merge Join, Hash Join）。 * **高级执行计划概念：** 学习 Compute Scalar, Stream Aggregate, Hash Aggregate, Left/Right Semi/Anti Join, Segment, Sequence, Project, Lazy Spool, Eager Spool 等操作符。 * **并发与性能：** 理解 Parallelism（Distribute Stream, Gather Stream, Repartition Stream）以及 Halloween Problem。 * **DML 操作执行计划：** 分析 INSERT, DELETE, UPDATE 操作的执行计划。 * **性能调优模式：** 学习如何通过识别执行计划中的模式（如 Merge Join Patterns, Hash Join Patterns, Key Lookup Patterns, Sort/Aggregate/Parallelism Indicators）来优化查询。 * **特殊优化技术：** 探讨参数嗅探（Parameter Sniffing）和 Parameter Sensitive Plan Optimization in SQL Server 2022。 * **警告与诊断：** 识别执行计划中的警告信息。 **课程收益：** 通过本课程，您将能够熟练阅读和理解 SQL Server 的执行计划，从而有效地诊断和优化 T-SQL 命令的性能。
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 topicsIndex Concepts in SQL ServerPage in SQL ServerExtent in SQL ServerHeap in SQL ServerClustered IndexNon Clustered IndexHeap with Non Clustered IndexIndexes are not very DeepComposite IndexIndex FragmentationIndex Creation using T-SQL CommandsIndex Rebuild and ReOrganizeFillFactorIncluded ColumnsData Type on Clustered IndexExecution PlanStatisticsActual Execution PlanEstimated Execution PlanCommon OperatorsTable Scan Index Scan Index Seek Key LookupRowID Lookup Nested Loop SortMerge JoinHash JoinCompute ScalarStream AggregateHash AggregateLeft Semi JoinRight Semi JoinLeft Anti Semi JoinRight Anti Semi JoinSegment Sequence ProjectLazy SpoolEager SpoolParallelism - Distribute Stream ,Gather Stream & Repartition StreamMore on Execution PlansHalloween ProblemExecution Plan of Insert OperationExecution Plan of Delete OperationExecution Plan of Update OperationSubtree cost related to ParallelismSubtree Cost of Stream and Hash AggregateIndex supports Wild CardPatterns to Note to Tune QueriesParameter Sniffing Parameter Sensitive Plan Optimization in Sql Server 2022MergeJoin PatternsHash Join PatternsKey Lookup PatternsSort Indicators Aggregate IndicatorsParallelism IndicatorsWarnings in Execution Plan From this course you will learn how to read and understand execution plans which will help in tuning Transact SQL Commands
