数据库里有100万条数据，6个字段，在一秒钟查询出来的优化，主键用numeric型，两种sql语名查询
[color=red][b]select * from (select row_number() over (order by id) as rownumber,* from flow) as t where t.rownumber between 434000 and 434044
[/b][/color]
[color=red][b]select top 10 * from flow where id not in (select top 434000 id from flow)
[/b][/color]
第一条要比第二条快1s
[color=red][b]select * from (select row_number() over (order by id) as rownumber,* from flow) as t where t.rownumber between 434000 and 434044
[/b][/color]
[color=red][b]select top 10 * from flow where id not in (select top 434000 id from flow)
[/b][/color]
第一条要比第二条快1s
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
