ÂÛÁÐÀÒÜ ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû.Ïåðèîä, ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû.ÂèäÄåíåæíûõÑðåäñòâ, ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû.ÏðèõîäÐàñõîä, ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû.ÑòàòüÿÄâèæåíèÿÄåíåæíûõÑðåäñòâ, ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû.ÑóììàÎáîðîò, ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû.ÑóììàÓïðÎáîðîò ÈÇ ÐåãèñòðÍàêîïëåíèÿ.ÄâèæåíèÿÄåíåæíûõÑðåäñòâ.Îáîðîòû( &Íà÷àëîÏåðèîäà, &ÊîíåöÏåðèîäà, Ìåñÿö, ÂèäÄåíåæíûõÑðåäñòâ = &ÂèäÄåíåæíûõÑðåäñòâ) ÊÀÊ ÄâèæåíèÿÄåíåæíûõÑðåäñòâÎáîðîòû Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 0 0 Compute Scalar(DEFINE:([Expr1006]=CONVERT(numeric(33,8),[Expr1004],0), [Expr1007]=CONVERT(numeric(33,8),[Expr1005],0))) 0 0 Compute Scalar Compute Scalar DEFINE:([Expr1006]=CONVERT(numeric(33,8),[Expr1004],0), [Expr1007]=CONVERT(numeric(33,8),[Expr1005],0)) [Expr1006]=CONVERT(numeric(33,8),[Expr1004],0), [Expr1007]=CONVERT(numeric(33,8),[Expr1005],0) 108,823 0 1,08823E-005 97 0,106528 [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [Expr1003], [Expr1006], [Expr1007] PLAN_ROW 0 1 23 1 |--Filter(WHERE:(CONVERT(numeric(33,8),[Expr1004],0)<>(0.00000000) OR CONVERT(numeric(33,8),[Expr1005],0)<>(0.00000000))) 0 1 0 Filter Filter WHERE:(CONVERT(numeric(33,8),[Expr1004],0)<>(0.00000000) OR CONVERT(numeric(33,8),[Expr1005],0)<>(0.00000000)) 108,823 0 0,000117539 97 0,106517 [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [Expr1003], [Expr1004], [Expr1005] PLAN_ROW 0 1 25 1 |--Hash Match(Aggregate, HASH:([Expr1003], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef]), RESIDUAL:([Expr1003] = [Expr1003] AND [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15575RRef] as [T2].[_Fld15575RRef] = [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15575RRef] as [T2].[_Fld15575RRef] AND [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15577RRef] as [T2].[_Fld15577RRef] = [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15577RRef] as [T2].[_Fld15577RRef]) DEFINE:([Expr1004]=SUM([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15587] as [T2].[_Fld15587]), [Expr1005]=SUM([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15586] as [T2].[_Fld15586]), [T2].[_Fld15574RRef]=ANY([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15574RRef] as [T2].[_Fld15574RRef]))) 0 2 1 Hash Match Aggregate HASH:([Expr1003], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef]), RESIDUAL:([Expr1003] = [Expr1003] AND [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15575RRef] as [T2].[_Fld15575RRef] = [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15575RRef] as [T2].[_Fld15575RRef] AND [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15577RRef] as [T2].[_Fld15577RRef] = [Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15577RRef] as [T2].[_Fld15577RRef]) [Expr1004]=SUM([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15587] as [T2].[_Fld15587]), [Expr1005]=SUM([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15586] as [T2].[_Fld15586]), [T2].[_Fld15574RRef]=ANY([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15574RRef] as [T2].[_Fld15574RRef]) 108,833 0 0,0407216 97 0,106399 [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [Expr1003], [Expr1004], [Expr1005] PLAN_ROW 0 1 0 0 |--Compute Scalar(DEFINE:([Expr1003]=dateadd(day,(0),dateadd(month,CONVERT_IMPLICIT(int,CONVERT(numeric(4,0),datepart(month,[Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Period] as [T2].[_Period]),0)-(1.),0),dateadd(year,CONVERT_IMPLICIT(int,(CONVERT(numeric(4,0),datepart(year,[Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Period] as [T2].[_Period]),0)-(2000.))-(2000.),0),'4000-01-01 00:00:00.000'))))) 0 3 2 Compute Scalar Compute Scalar DEFINE:([Expr1003]=dateadd(day,(0),dateadd(month,CONVERT_IMPLICIT(int,CONVERT(numeric(4,0),datepart(month,[Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Period] as [T2].[_Period]),0)-(1.),0),dateadd(year,CONVERT_IMPLICIT(int,(CONVERT(numeric(4,0),datepart(year,[Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Period] as [T2].[_Period]),0)-(2000.))-(2000.),0),'4000-01-01 00:00:00.000')))) [Expr1003]=dateadd(day,(0),dateadd(month,CONVERT_IMPLICIT(int,CONVERT(numeric(4,0),datepart(month,[Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Period] as [T2].[_Period]),0)-(1.),0),dateadd(year,CONVERT_IMPLICIT(int,(CONVERT(numeric(4,0),datepart(year,[Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Period] as [T2].[_Period]),0)-(2000.))-(2000.),0),'4000-01-01 00:00:00.000'))) 2244,5 0 0,00022445 89 0,0656779 [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [T2].[_Fld15586], [T2].[_Fld15587], [Expr1003] PLAN_ROW 0 1 2293 1 |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1016], [Expr1017], [Expr1018])) 0 4 3 Nested Loops Inner Join OUTER REFERENCES:([Expr1016], [Expr1017], [Expr1018]) 2244,5 0,0616435 0,0027002 89 0,0643437 [T2].[_Period], [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [T2].[_Fld15586], [T2].[_Fld15587] PLAN_ROW 0 1 1 1 |--Merge Interval 0 5 4 Merge Interval Merge Interval 2 0 0 27 0 [Expr1016], [Expr1017], [Expr1018] PLAN_ROW 0 1 2 1 | |--Concatenation 0 6 5 Concatenation Concatenation [Expr1016] = ([Expr1011], [Expr1014]), [Expr1017] = ([Expr1012], [Expr1015]), [Expr1018] = ([Expr1010], [Expr1013]) 2 0 0 27 0 [Expr1016], [Expr1017], [Expr1018] PLAN_ROW 0 1 1 1 | |--Compute Scalar(DEFINE:(([Expr1011],[Expr1012],[Expr1010])=GetRangeWithMismatchedTypes([@P1],NULL,(22)))) 0 7 6 Compute Scalar Compute Scalar DEFINE:(([Expr1011],[Expr1012],[Expr1010])=GetRangeWithMismatchedTypes([@P1],NULL,(22))) ([Expr1011],[Expr1012],[Expr1010])=GetRangeWithMismatchedTypes([@P1],NULL,(22)) 1 0 0 27 0 [Expr1011], [Expr1012], [Expr1010] PLAN_ROW 0 1 1 1 | | |--Constant Scan 0 8 7 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1 1 1 | |--Compute Scalar(DEFINE:(([Expr1014],[Expr1015],[Expr1013])=GetRangeWithMismatchedTypes(NULL,[@P2],(10)))) 0 12 6 Compute Scalar Compute Scalar DEFINE:(([Expr1014],[Expr1015],[Expr1013])=GetRangeWithMismatchedTypes(NULL,[@P2],(10))) ([Expr1014],[Expr1015],[Expr1013])=GetRangeWithMismatchedTypes(NULL,[@P2],(10)) 1 0 0 27 0 [Expr1014], [Expr1015], [Expr1013] PLAN_ROW 0 1 1 1 | |--Constant Scan 0 13 12 Constant Scan Constant Scan 1 0 0 0 0 PLAN_ROW 0 1 2293 1 |--Clustered Index Seek(OBJECT:([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Accum15592_ByDims_TRRRRRRRN] AS [T2]), SEEK:([T2].[_Period] > [Expr1016] AND [T2].[_Period] < [Expr1017]), WHERE:([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15574RRef] as [T2].[_Fld15574RRef]=[@P3]) ORDERED FORWARD) 0 17 4 Clustered Index Seek Clustered Index Seek OBJECT:([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Accum15592_ByDims_TRRRRRRRN] AS [T2]), SEEK:([T2].[_Period] > [Expr1016] AND [T2].[_Period] < [Expr1017]), WHERE:([Test_Kurs_Optimization].[dbo].[_AccumRgTn15592].[_Fld15574RRef] as [T2].[_Fld15574RRef]=[@P3]) ORDERED FORWARD [T2].[_Period], [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [T2].[_Fld15586], [T2].[_Fld15587] 2244,5 0,0616435 0,0027002 89 0,0643437 [T2].[_Period], [T2].[_Fld15574RRef], [T2].[_Fld15575RRef], [T2].[_Fld15577RRef], [T2].[_Fld15586], [T2].[_Fld15587] PLAN_ROW 0 1