Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 2 1 Hash Match(Left Anti Semi Join, HASH:([T1].[_IDRRef])=([T2].[_Fld20RRef]), RESIDUAL:([Kurs].[dbo].[_Reference7].[_IDRRef] as [T1].[_IDRRef]=[Kurs].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef])) 0 0 Hash Match Left Anti Semi Join HASH:([T1].[_IDRRef])=([T2].[_Fld20RRef]), RESIDUAL:([Kurs].[dbo].[_Reference7].[_IDRRef] as [T1].[_IDRRef]=[Kurs].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef]) 128,177 0 0,111646 52 0,21041 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 1007 1 |--Index Scan(OBJECT:([Kurs].[dbo].[_Reference7].[_Reference7_Descr_SR] AS [T1])) 0 1 0 Index Scan Index Scan OBJECT:([Kurs].[dbo].[_Reference7].[_Reference7_Descr_SR] AS [T1]) [T1].[_IDRRef], [T1].[_Description] 1007 0,0068287 0,0012647 52 0,0080934 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 8061 1 |--Clustered Index Scan(OBJECT:([Kurs].[dbo].[_AccumRg18].[_AccumRg18_ByPeriod_TRN] AS [T2])) 0 2 0 Clustered Index Scan Clustered Index Scan OBJECT:([Kurs].[dbo].[_AccumRg18].[_AccumRg18_ByPeriod_TRN] AS [T2]) [T2].[_Fld20RRef] 8061 0,0816435 0,0090241 23 0,0906676 [T2].[_Fld20RRef] PLAN_ROW 0 1 в тестовой Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 512 1 Merge Join(Right Anti Semi Join, MERGE:([T2].[_Fld58RRef])=([T1].[_IDRRef]), RESIDUAL:([testbase].[dbo].[_Reference12].[_IDRRef] as [T1].[_IDRRef]=[testbase].[dbo].[_AccumRg57].[_Fld58RRef] as [T2].[_Fld58RRef])) 0 0 Merge Join Right Anti Semi Join MERGE:([T2].[_Fld58RRef])=([T1].[_IDRRef]), RESIDUAL:([testbase].[dbo].[_Reference12].[_IDRRef] as [T1].[_IDRRef]=[testbase].[dbo].[_AccumRg57].[_Fld58RRef] as [T2].[_Fld58RRef]) 610,65 0 0,00885307 107 0,0497421 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 504 1 |--Sort(DISTINCT ORDER BY:([T2].[_Fld58RRef] ASC)) 0 1 0 Sort Distinct Sort DISTINCT ORDER BY:([T2].[_Fld58RRef] ASC) 504 0,0112613 0,0073048 23 0,0268568 [T2].[_Fld58RRef] PLAN_ROW 0 1 513 1 | |--Clustered Index Scan(OBJECT:([testbase].[dbo].[_AccumRg57].[_AccumRg57_ByPeriod_TRN] AS [T2])) 0 2 1 Clustered Index Scan Clustered Index Scan OBJECT:([testbase].[dbo].[_AccumRg57].[_AccumRg57_ByPeriod_TRN] AS [T2]) [T2].[_Fld58RRef] 513 0,00756944 0,0007213 23 0,00829074 [T2].[_Fld58RRef] PLAN_ROW 0 1 1016 1 |--Clustered Index Scan(OBJECT:([testbase].[dbo].[_Reference12].[PK___Referen__AC8ED0C410766AC2] AS [T1]), ORDERED FORWARD) 0 3 0 Clustered Index Scan Clustered Index Scan OBJECT:([testbase].[dbo].[_Reference12].[PK___Referen__AC8ED0C410766AC2] AS [T1]), ORDERED FORWARD [T1].[_IDRRef], [T1].[_Description] 1016 0,0127546 0,0012746 107 0,0140292 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 1012 1 Merge Join(Right Anti Semi Join, MERGE:([T2].[_Fld58RRef])=([T1].[_IDRRef]), RESIDUAL:([testbase].[dbo].[_Reference12].[_IDRRef] as [T1].[_IDRRef]=[testbase].[dbo].[_AccumRg57].[_Fld58RRef] as [T2].[_Fld58RRef])) 0 0 Merge Join Right Anti Semi Join MERGE:([T2].[_Fld58RRef])=([T1].[_IDRRef]), RESIDUAL:([testbase].[dbo].[_Reference12].[_IDRRef] as [T1].[_IDRRef]=[testbase].[dbo].[_AccumRg57].[_Fld58RRef] as [T2].[_Fld58RRef]) 610,65 0 0,00885307 107 0,0497421 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 4 1 |--Sort(DISTINCT ORDER BY:([T2].[_Fld58RRef] ASC)) 0 1 0 Sort Distinct Sort DISTINCT ORDER BY:([T2].[_Fld58RRef] ASC) 504 0,0112613 0,0073048 23 0,0268568 [T2].[_Fld58RRef] PLAN_ROW 0 1 9 1 | |--Clustered Index Scan(OBJECT:([testbase].[dbo].[_AccumRg57].[_AccumRg57_ByPeriod_TRN] AS [T2])) 0 2 1 Clustered Index Scan Clustered Index Scan OBJECT:([testbase].[dbo].[_AccumRg57].[_AccumRg57_ByPeriod_TRN] AS [T2]) [T2].[_Fld58RRef] 513 0,00756944 0,0007213 23 0,00829074 [T2].[_Fld58RRef] PLAN_ROW 0 1 1016 1 |--Clustered Index Scan(OBJECT:([testbase].[dbo].[_Reference12].[PK___Referen__AC8ED0C410766AC2] AS [T1]), ORDERED FORWARD) 0 3 0 Clustered Index Scan Clustered Index Scan OBJECT:([testbase].[dbo].[_Reference12].[PK___Referen__AC8ED0C410766AC2] AS [T1]), ORDERED FORWARD [T1].[_IDRRef], [T1].[_Description] 1016 0,0127546 0,0012746 107 0,0140292 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1