OFFSET...FETCH is a SQL Server 2012 extension to the ORDER BY clause aimed at simplifying paging applications.

learn more… | top users | synonyms

9
votes
3answers
720 views

Why are there execution plan differences between OFFSET … FETCH and the old-style ROW_NUMBER scheme?

The new OFFSET ... FETCH model introduces with SQL Server 2012 offers simple and faster paging. Why are there any differences at all considering that the two forms are semantically identical and very ...