[步骤]
(@P0 int,@P1 int)SELECT TOP 1000 ID,orderSourceID,sku,asin,AddTime,[product-group] as productGroup from RB_FBA_INVENTORY_PLANNING_DATA(nolock) where OrderSourceID =@P0 and CustomerID = 1 and ID>@P1 order by ID asc
采用ID 排序 数据量大 会消耗大量资源 造成极大的阻塞
[结果]
读库大量延迟[期望]
不需要排序 采用ID 范围 获取