深圳智汇创想科技有限公司

[步骤]

(@CustomerID0Union1 int,@OperateType1Union1 int,@MethodConst2Union1 datetime,@MethodConst3Union1 datetime,@CustomerID0Union2 int,@OperateType1Union2 int,@MethodConst2Union2 datetime,@MethodConst3Union2 datetime)SELECT  TOP 1000  [Id] AS [Id] , [CustomerId] AS [CustomerId] , [OrderSourceId] AS [OrderSourceId] , [OrderCode] AS [OrderCode] , [OperateType] AS [OperateType] , [OperateFee] AS [OperateFee] , [OperateTime] AS [OperateTime] , [IsConfirm] AS [IsConfirm] , [ConfirmTime] AS [ConfirmTime] , [RelateId] AS [RelateId] , [Currency] AS [Currency] , [ExchangeRMB] AS [ExchangeRMB] , [SKU] AS [SKU] , [USD_ExchangeRMB] AS [USD_ExchangeRMB] , [SellerSKU] AS [SellerSKU] , [GroupSKU] AS [GroupSKU] , [AddTime] AS [AddTime] , [UpdateTime] AS [UpdateTime]  FROM  (SELECT * FROM  (SELECT  [ID] AS [Id] , [CustomerID] AS [CustomerId] , [OrderSourceID] AS [OrderSourceId] , [OrderCode] AS [OrderCode] , [OperateType] AS [OperateType] , [OperateFee] AS [OperateFee] , [OperateTime] AS [OperateTime] , [IsConfirm] AS [IsConfirm] , [ConfirmTime] AS [ConfirmTime] , [RelateID] AS [RelateId] , [Currency] AS [Currency] , [ExchangeRMB] AS [ExchangeRMB] , [SKU] AS [SKU] , [USD_ExchangeRMB] AS [USD_ExchangeRMB] , [SellerSKU] AS [SellerSKU] , [GroupSKU] AS [GroupSKU] , [AddTime] AS [AddTime] , [UpdateTime] AS [UpdateTime]  FROM [RB_Product_Fee] WITH(NOLOCK)   WHERE ((( [CustomerID] = @CustomerID0Union1 ) AND ( [OperateType] = @OperateType1Union1 )) AND  ([UpdateTime] BETWEEN @MethodConst2Union1 AND @MethodConst3Union1) ) UNION   SELECT  [ID] AS [Id] , [CustomerID] AS [CustomerId] , [OrderSourceID] AS [OrderSourceId] , [OrderCode] AS [OrderCode] , [OperateType] AS [OperateType] , [OperateFee] AS [OperateFee] , [OperateTime] AS [OperateTime] , [IsConfirm] AS [IsConfirm] , [ConfirmTime] AS [ConfirmTime] , [RelateID] AS [RelateId] , [Currency] AS [Currency] , [ExchangeRMB] AS [ExchangeRMB] , [SKU] AS [SKU] , [USD_ExchangeRMB] AS [USD_ExchangeRMB] , [SellerSKU] AS [SellerSKU] , [GroupSKU] AS [GroupSKU] , [AddTime] AS [AddTime] , [UpdateTime] AS [UpdateTime]  FROM [RB_Product_Fee] WITH(NOLOCK)   WHERE ((( [CustomerID] = @CustomerID0Union2 ) AND ( [OperateType] = @OperateType1Union2 )) AND  ([AddTime] BETWEEN @MethodConst2Union2 AND @MethodConst3Union2) )) unionTable  ) MergeTable  ORDER BY [Id] ASC

运行时间久 对系统影响大 表已经达到十亿级别

表数据量大不要用ID 排序

[结果]

[期望]