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.
Articles
Page 11 of 11
— showing articles
181 to
182
of 182
The “Segment Top” Query Optimization
Why you will sometimes see a Top operator directly above a Segment operator in SQL Server execution plans.