Текст запроса: 1C: ВЫБРАТЬ ТоварыНаСкладахОстатки.Номенклатура ИЗ РегистрНакопления.ТоварыНаСкладах.Остатки(, ХарактеристикаНоменклатуры = &ХарактеристикаНоменклатуры) КАК ТоварыНаСкладахОстатки SQL: exec sp_executesql N'SELECT T1.Fld5065RRef FROM (SELECT T2._Fld5065RRef AS Fld5065RRef, CAST(SUM(T2._Fld5069) AS NUMERIC(32, 8)) AS Fld5069Balance_ FROM dbo._AccumRgT5071 T2 WITH(NOLOCK) WHERE T2._Period = @P1 AND ((T2._Fld5066RRef = @P2)) AND (T2._Fld5069 <> @P3) AND (T2._Fld5069 <> @P4) GROUP BY T2._Fld5065RRef HAVING (CAST(SUM(T2._Fld5069) AS NUMERIC(32, 8))) <> @P5) T1',N'@P1 datetime2(3),@P2 varbinary(16),@P3 numeric(10),@P4 numeric(10),@P5 numeric(10)','3999-11-01 00:00:00',0x00000000000000000000000000000000,0,0,0 План запроса: Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 3217 1 Filter(WHERE:(CONVERT(numeric(32,8),[Expr1002],0)<>CONVERT_IMPLICIT(numeric(32,8),[@P5],0))) 0 0 Filter Filter WHERE:(CONVERT(numeric(32,8),[Expr1002],0)<>CONVERT_IMPLICIT(numeric(32,8),[@P5],0)) 4124,23 0 0,00239263 23 0,305308 [T2].[_Fld5065RRef] PLAN_ROW 0 1 3224 1 |--Hash Match(Aggregate, HASH:([T2].[_Fld5065RRef]), RESIDUAL:([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5065RRef] as [T2].[_Fld5065RRef] = [TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5065RRef] as [T2].[_Fld5065RRef]) DEFINE:([Expr1002]=SUM([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5069] as [T2].[_Fld5069]))) 0 1 0 Hash Match Aggregate HASH:([T2].[_Fld5065RRef]), RESIDUAL:([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5065RRef] as [T2].[_Fld5065RRef] = [TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5065RRef] as [T2].[_Fld5065RRef]) [Expr1002]=SUM([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5069] as [T2].[_Fld5069]) 4125,23 0 0,195361 40 0,302916 [T2].[_Fld5065RRef], [Expr1002] PLAN_ROW 0 1 3779 1 |--Clustered Index Seek(OBJECT:([TRADE_TEST].[dbo].[_AccumRgT5071].[_AccumR5071_ByDims_TRRRRR] AS [T2]), SEEK:([T2].[_Period]=[@P1]), WHERE:([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5066RRef] as [T2].[_Fld5066RRef]=[@P2] AND ([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5069] as [T2].[_Fld5069]CONVERT_IMPLICIT(numeric(21,3),[@P3],0)) AND ([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5069] as [T2].[_Fld5069]CONVERT_IMPLICIT(numeric(21,3),[@P4],0))) ORDERED FORWARD) 0 2 1 Clustered Index Seek Clustered Index Seek OBJECT:([TRADE_TEST].[dbo].[_AccumRgT5071].[_AccumR5071_ByDims_TRRRRR] AS [T2]), SEEK:([T2].[_Period]=[@P1]), WHERE:([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5066RRef] as [T2].[_Fld5066RRef]=[@P2] AND ([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5069] as [T2].[_Fld5069]CONVERT_IMPLICIT(numeric(21,3),[@P3],0)) AND ([TRADE_TEST].[dbo].[_AccumRgT5071].[_Fld5069] as [T2].[_Fld5069]CONVERT_IMPLICIT(numeric(21,3),[@P4],0))) ORDERED FORWARD [T2].[_Fld5065RRef], [T2].[_Fld5069] 7361,29 0,0837069 0,00861809 52 0,092325 [T2].[_Fld5065RRef], [T2].[_Fld5069] PLAN_ROW 0 1