自己写的分页sql存在严重性能问题

Question

select * from(select row_number() over(order by bt.CustomerId desc) RowNum,cb.CustomerName,bt.BizTrackId as Identification,bt.NewBuyCycle,bt.TrackDate,bt.NextTrackDate,uu.UserName as SaleName,bt.BusinessStage,bt.CustomerExpectations,bt.TrackDescription,bt.SaleMgrOpinion,o.OrganizationName
from tb_BizTrack as bt
left join tb_CustomerBasic as cb on cb.CustomerId=bt.CustomerId
left join tb_UbacUser as uu on uu.UserId=cb.SaleId
left join tb_Organization as o on o.OrganizationId=cb.CustomerOrg
left join tb_BizOppty as bo on bo.CustomerId=cb.CustomerId
where SaleMgrOpinion is null and bt.IsDelete=0 and bo.BizStatus=0) as temp where temp.RowNum between 20121 and 20140

当数据量上万后，查询尾页，比如20121dapper20140条时，在Sqlserver查询就需要40多秒，导致系统报错“查询超时”
请问各位大神 我这个可以优化一下吗，谢谢

Answer 1

sqlserver就是这样啊 数据量很大的情况下查询很慢 sqlserver和oracle查询方式不一样
oracle就会快很多