?
use mastergoset nocount ongoset showplan_text ongo--2012的OFFSET分页方式select number from spt_valueswhere type='p'order by number offset 10 rows fetch next 5 rows only;go--2005的ROW_NUMBER分页方式select number from (select number,row_number() over(order by number) as num from spt_values where type='p') t where num between 11 and 15order by number ascgo--2000的TOP分页方式select number from (select top 5 number from (select top 15 number from spt_values where type='p' order by number asc) torder by number desc) t order by number ascgoset showplan_text offgo
? ?从查询计划来看，2012的查询计划中，offset直接操作了top迭代器，分页计划十分简单，看起来也比后两种简单明了，而在系统预估的查询开销中，OFFSET占9%，ROW_NUMBER占45%，TOP占47%（加起来101% -_-||），OFFSET占了绝对的优势。