SELECT регSQL.Фирма as [Фирма $Справочник.Фирмы] , регSQL.Товар as [Товар $Справочник.Номенклатура] , регSQL.ПоСчету as [ПоСчету $Документ] , регSQL.Договор as [Договор $Справочник.Договора] , регSQL.РезервТовараОстаток as РезервТовар 761 302 0 NULL NULL 153 NULL 47.006531 NULL NULL NULL 4.4473543 NULL NULL SELECT 0 NULL |--Filter(WHERE:([Expr1013]<>0.00000)) 761 303 302 Filter Filter WHERE:([Expr1013]<>0.00000) NULL 47.006531 0.0 3.4381374E-5 64 4.4473543 [Union1008], [Union1009], [Union1010], [Union1011], [Expr1013] NULL PLAN_ROW 0 1.0 |--Compute Scalar(DEFINE:([Expr1013]=If ([Expr1020]=0) then NULL else [Expr1021])) 761 304 303 Compute Scalar Compute Scalar DEFINE:([Expr1013]=If ([Expr1020]=0) then NULL else [Expr1021]) [Expr1013]=If ([Expr1020]=0) then NULL else [Expr1021] 71.627861 0.0 5.3362752E-4 64 4.44732 [Union1008], [Union1009], [Union1010], [Union1011], [Expr1013] NULL PLAN_ROW 0 1.0 |--Stream Aggregate(GROUP BY:([Union1008], [Union1009], [Union1010], [Union1011]) DEFINE:([Expr1020]=COUNT_BIG([Union1012]), [Expr1021]=SUM([Union1012]))) 761 305 304 Stream Aggregate Aggregate GROUP BY:([Union1008], [Union1009], [Union1010], [Union1011]) [Expr1020]=COUNT_BIG([Union1012]), [Expr1021]=SUM([Union1012]) 71.627861 0.0 5.3362752E-4 64 4.44732 [Union1008], [Union1009], [Union1010], [Union1011], [Expr1020], [Expr1021] NULL PLAN_ROW 0 1.0 |--Sort(ORDER BY:([Union1008] ASC, [Union1009] ASC, [Union1010] ASC, [Union1011] ASC)) 761 306 305 Sort Sort ORDER BY:([Union1008] ASC, [Union1009] ASC, [Union1010] ASC, [Union1011] ASC) NULL 71.627861 1.1261261E-2 7.8858872E-4 56 4.4467864 [Union1008], [Union1009], [Union1010], [Union1011], [Union1012] NULL PLAN_ROW 0 1.0 |--Concatenation 761 307 306 Concatenation Concatenation NULL [Union1008] = ([rg620_vt].[SP10406], [ra620_vt].[SP10406]), [Union1009] = ([rg620_vt].[SP621], [ra620_vt].[SP621]), [Union1010] = ([rg620_vt].[SP622], [ra620_vt].[SP622]), [Union1011] = ([rg620_vt].[SP6158], [ra620_vt].[SP6158]), [Union1012] = ([rg620_vt]. 71.627861 0.0 7.162786E-6 56 4.4347363 [Union1008], [Union1009], [Union1010], [Union1011], [Union1012] NULL PLAN_ROW 0 1.0 |--Nested Loops(Inner Join, OUTER REFERENCES:(@tabl_2.[val])) 761 309 307 Nested Loops Inner Join OUTER REFERENCES:(@tabl_2.[val]) NULL 6.5276637 0.0 8.1856902E-5 113 5.5765454E-2 [rg620_vt].[SP623], [rg620_vt].[SP6158], [rg620_vt].[SP622], [rg620_vt].[SP621], [rg620_vt].[SP10406] NULL PLAN_ROW 0 1.0 | |--Sort(DISTINCT ORDER BY:(@tabl_2.[val] ASC)) 761 310 309 Sort Distinct Sort DISTINCT ORDER BY:(@tabl_2.[val] ASC) NULL 1.0 1.1261261E-2 9.9999997E-5 16 4.9019363E-2 @tabl_2.[val] NULL PLAN_ROW 0 1.0 | | |--Table Scan(OBJECT:(@tabl_2)) 761 311 310 Table Scan Table Scan OBJECT:(@tabl_2) @tabl_2.[val] 1.0 3.7578501E-2 7.9600002E-5 24 3.7658099E-2 @tabl_2.[val] NULL PLAN_ROW 0 1.0 | |--Clustered Index Seek(OBJECT:([s2006_office].[dbo].[RG620].[PK_RG620] AS [rg620_vt]), SEEK:([rg620_vt].[PERIOD]='Dec 1 2008 12:00AM' AND [rg620_vt].[SP10406]=' 0 ' AND [rg620_vt].[SP621]=@tabl_2.[val]) ORDERED FORWA 761 312 309 Clustered Index Seek Clustered Index Seek OBJECT:([s2006_office].[dbo].[RG620].[PK_RG620] AS [rg620_vt]), SEEK:([rg620_vt].[PERIOD]='Dec 1 2008 12:00AM' AND [rg620_vt].[SP10406]=' 0 ' AND [rg620_vt].[SP621]=@tabl_2.[val]) ORDERED FORWARD [rg620_vt].[SP623], [rg620_vt].[SP6158], [rg620_vt].[SP622], [rg620_vt].[SP621], [rg620_vt].[SP10406] 6.5276637 6.3284999E-3 8.5745705E-5 104 6.664237E-3 [rg620_vt].[SP623], [rg620_vt].[SP6158], [rg620_vt].[SP622], [rg620_vt].[SP621], [rg620_vt].[SP10406] NULL PLAN_ROW 0 3.0 |--Compute Scalar(DEFINE:([Expr1007]=If (Convert([ra620_vt].[DEBKRED])=0) then [ra620_vt].[SP623] else ( -[ra620_vt].[SP623]))) 761 314 307 Compute Scalar Compute Scalar DEFINE:([Expr1007]=If (Convert([ra620_vt].[DEBKRED])=0) then [ra620_vt].[SP623] else ( -[ra620_vt].[SP623])) [Expr1007]=If (Convert([ra620_vt].[DEBKRED])=0) then [ra620_vt].[SP623] else ( -[ra620_vt].[SP623]) 65.100197 0.0 6.5100194E-6 56 4.378963 [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406], [Expr1007] NULL PLAN_ROW 0 1.0 |--Filter(WHERE:(([j620_vt].[RF620]=1 AND [j620_vt].[DATE_TIME_IDDOC]>'20090101') AND [j620_vt].[DATE_TIME_IDDOC]<'20090110Z')) 761 315 314 Filter Filter WHERE:(([j620_vt].[RF620]=1 AND [j620_vt].[DATE_TIME_IDDOC]>'20090101') AND [j620_vt].[DATE_TIME_IDDOC]<'20090110Z') NULL 65.100197 0.0 7.6818229E-5 245 4.3789568 [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406] NULL PLAN_ROW 0 1.0 |--Bookmark Lookup(BOOKMARK:([Bmk1004]), OBJECT:([s2006_office].[dbo].[_1SJOURN] AS [j620_vt])) 761 316 315 Bookmark Lookup Bookmark Lookup BOOKMARK:([Bmk1004]), OBJECT:([s2006_office].[dbo].[_1SJOURN] AS [j620_vt]) [j620_vt].[RF620], [j620_vt].[DATE_TIME_IDDOC] 65.100197 0.1999952 7.1610215E-5 245 4.3788795 [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406], [j620_vt].[RF620], [j620_vt].[DATE_TIME_IDDOC] NULL PLAN_ROW 0 1.0 |--Parallelism(Gather Streams) 761 318 316 Parallelism Gather Streams NULL NULL 65.100197 0.0 2.9098108E-2 125 4.178813 [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406], [Bmk1004] NULL PLAN_ROW -1 1.0 |--Nested Loops(Inner Join, OUTER REFERENCES:([ra620_vt].[IDDOC]) WITH PREFETCH) 761 319 318 Nested Loops Inner Join OUTER REFERENCES:([ra620_vt].[IDDOC]) WITH PREFETCH NULL 65.100197 0.0 1.360594E-4 125 4.1497149 [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406], [Bmk1004] NULL PLAN_ROW -1 1.0 |--Nested Loops(Left Semi Join, WHERE:([ra620_vt].[SP621]=@tabl_2.[val])) 761 321 319 Nested Loops Left Semi Join WHERE:([ra620_vt].[SP621]=@tabl_2.[val]) NULL 65.100197 0.0 0.70682687 96 4.1364055 [ra620_vt].[IDDOC], [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406] NULL PLAN_ROW -1 1.0 | |--Clustered Index Scan(OBJECT:([s2006_office].[dbo].[RA620].[PK_RA620] AS [ra620_vt]), WHERE:([ra620_vt].[SP10406]=' 0 ') ORDERED FORWARD) 761 322 321 Clustered Index Scan Clustered Index Scan OBJECT:([s2006_office].[dbo].[RA620].[PK_RA620] AS [ra620_vt]), WHERE:([ra620_vt].[SP10406]=' 0 ') ORDERED FORWARD [ra620_vt].[IDDOC], [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406], [KeyCo2], [KeyCo3] 338194.66 2.8886895 0.2256795 96 3.1143692 [ra620_vt].[IDDOC], [ra620_vt].[DEBKRED], [ra620_vt].[SP623], [ra620_vt].[SP6158], [ra620_vt].[SP622], [ra620_vt].[SP621], [ra620_vt].[SP10406], [KeyCo2], [KeyCo3] NULL PLAN_ROW -1 1.0 | |--Table Spool 761 323 321 Table Spool Lazy Spool NULL NULL 1.0 1.6756756E-2 2.7999999E-7 16 0.11529 @tabl_2.[val] NULL PLAN_ROW -1 338194.66 | |--Table Scan(OBJECT:(@tabl_2)) 761 324 323 Table Scan Table Scan OBJECT:(@tabl_2) @tabl_2.[val] 1.0 3.7578501E-2 7.9600002E-5 24 3.7658099E-2 @tabl_2.[val] NULL PLAN_ROW -1 1.0 |--Index Seek(OBJECT:([s2006_office].[dbo].[_1SJOURN].[IDDOC] AS [j620_vt]), SEEK:([j620_vt].[IDDOC]=[ra620_vt].[IDDOC]) ORDERED FORWARD) 761 328 319 Index Seek Index Seek OBJECT:([s2006_office].[dbo].[_1SJOURN].[IDDOC] AS [j620_vt]), SEEK:([j620_vt].[IDDOC]=[ra620_vt].[IDDOC]) ORDERED FORWARD [Bmk1004] 1.0 3.2034251E-3 7.9603E-5 38 1.3173235E-2 [Bmk1004] NULL PLAN_ROW -1 65.100197