Inside the Optimizer: Constructing a Plan—Part 4
Exploring the internal operation of the SQL Server cost-based optimizer with DBCC RULEON and DBCC RULEOFF.
Articles
Page 11 of 11
— showing articles
181 to
188
of 188
Inside the Optimizer: Constructing a Plan—Part 3
Using an undocumented DMV to explore the rules used by the SQL Server query optimizer to generate a good execution plan.
Inside the Optimizer: Constructing a Plan—Part 2
How the SQL Server query optimizer matches and applies internal rules to refine an execution plan.
Inside the Optimizer: Constructing a Plan—Part 1
The rules the SQL Server cost-based query optimizer uses to build an execution plan.
Ranking Function Optimizer Transformations
SQL Server execution plans for window functions including the Segment Spool plan shape. How you can get a window function plan without writing the OVER clause.
Partitioning and the Common Subexpression Spool
The SQL Server common subexpression spool plan shape, and how it is used to implement queries using the OVER clause.
The Segment and Sequence Project Iterators
How the SQL Server Segment and Sequence Project operators are used to implement window functions like ROW_NUMBER, RANK, and DENSE_RANK.
The “Segment Top” Query Optimization
Why you will sometimes see a Top operator directly above a Segment operator in SQL Server execution plans.