Markus,
thanks for your reply.
The pipelined top-n query has two very important properties:
(1) it utilizes the index order to avoid the sort operation required to
satisfy ORDER BY clause
(2) it realizes that it can stop processing as soon as it has delivered
enough rows.
The
Behrang Saeedzadeh, 15.02.2014 02:35:
Hi,
I just stumbled upon this article from 2012 [1], according to which
(emphasis mine):
Window functions offer yet another way to implement pagination in
SQL. This is a flexible, and above all, standards-compliant method.
However, only SQL Server
