关于sql server 2005分页

数据库里有100万条数据，6个字段，在一秒钟查询出来的优化，主键用numeric型，两种sql语名查询
select * from (select row_number() over (order by id) as rownumber,* from flow) as t where t.rownumber between 434000 and 434044

select top 10 * from flow where id not in (select top 434000 id from flow)


第一条要比第二条快1s