关于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
页:
[1]