摘要:
单条SQL语句的分页,耗时计算--方法一 共耗时653毫秒declare @time1 datetime,@time2 datetimeset @time1=GETDATE();SELECT TOP 100 *FROM Test1WHERE id NOT IN ( SELECT TOP (50000*1) id FROM Test1 ORDER BY id )ORDER BY idset @time2=GETDATE();select datediff(millisecond,@time1,@time2);--方法2 共耗时436毫秒declare @time1 datetime,@time2 阅读全文