sql2008的比较快的分页

sql2008中用到的

性能比较好,测试过150万行的表,平均查询时间约为3-4秒

 

 DECLARE @Start INT 
 DECLARE @End INT 
 SELECT @Start = 0,@End =  50
 SELECT * 
 FROM ( 
  select  *,ROW_NUMBER() OVER (ORDER BY B_User.Add_Time desc) AS RowNumber  from  B_User ) QueryPage 
 WHERE RowNumber > @Start AND RowNumber <= @End 
ORDER BY B_User.Update_Time desc