SELECT T1._Description FROM dbo._Reference7 T1 WITH(NOLOCK) WHERE (NOT ((T1._IDRRef IN (SELECT T2._Fld20RRef AS Q_002_F_000RRef FROM dbo._AccumRg18 T2 WITH(NOLOCK))))) Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 0 1 Hash Match(Left Anti Semi Join, HASH:([T1].[_IDRRef])=([T2].[_Fld20RRef]), RESIDUAL:([TestBase83].[dbo].[_Reference7].[_IDRRef] as [T1].[_IDRRef]=[TestBase83].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef])) 0 0 Hash Match Left Anti Semi Join HASH:([T1].[_IDRRef])=([T2].[_Fld20RRef]), RESIDUAL:([TestBase83].[dbo].[_Reference7].[_IDRRef] as [T1].[_IDRRef]=[TestBase83].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef]) 1 0 0,117894 36 0,22738 [T1].[_Description] PLAN_ROW 0 1 1004 1 |--Index Scan(OBJECT:([TestBase83].[dbo].[_Reference7].[_Reference7_Descr_SR] AS [T1])) 0 1 0 Index Scan Index Scan OBJECT:([TestBase83].[dbo].[_Reference7].[_Reference7_Descr_SR] AS [T1]) [T1].[_IDRRef], [T1].[_Description] 1004 0,0068287 0,0012614 52 0,0080901 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 9057 1 |--Clustered Index Scan(OBJECT:([TestBase83].[dbo].[_AccumRg18].[_AccumRg18_ByPeriod_TRN] AS [T2])) 0 2 0 Clustered Index Scan Clustered Index Scan OBJECT:([TestBase83].[dbo].[_AccumRg18].[_AccumRg18_ByPeriod_TRN] AS [T2]) [T2].[_Fld20RRef] 9057 0,0912731 0,0101197 23 0,101393 [T2].[_Fld20RRef] PLAN_ROW 0 1 SELECT T1._Description FROM dbo._Reference7 T1 WITH(NOLOCK) LEFT OUTER JOIN dbo._AccumRg18 T2 WITH(NOLOCK) ON (T2._Fld20RRef = T1._IDRRef) WHERE T2._Fld20RRef IS NULL Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 0 1 Filter(WHERE:([TestBase83].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef] IS NULL)) 0 0 Filter Filter WHERE:([TestBase83].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef] IS NULL) 1 0 0,00434736 36 0,241678 [T1].[_Description] PLAN_ROW 0 1 9057 1 |--Hash Match(Left Outer Join, HASH:([T1].[_IDRRef])=([T2].[_Fld20RRef]), RESIDUAL:([TestBase83].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef]=[TestBase83].[dbo].[_Reference7].[_IDRRef] as [T1].[_IDRRef])) 0 1 0 Hash Match Left Outer Join HASH:([T1].[_IDRRef])=([T2].[_Fld20RRef]), RESIDUAL:([TestBase83].[dbo].[_AccumRg18].[_Fld20RRef] as [T2].[_Fld20RRef]=[TestBase83].[dbo].[_Reference7].[_IDRRef] as [T1].[_IDRRef]) 9057 0 0,127845 52 0,237331 [T1].[_Description], [T2].[_Fld20RRef] PLAN_ROW 0 1 1004 1 |--Index Scan(OBJECT:([TestBase83].[dbo].[_Reference7].[_Reference7_Descr_SR] AS [T1])) 0 2 1 Index Scan Index Scan OBJECT:([TestBase83].[dbo].[_Reference7].[_Reference7_Descr_SR] AS [T1]) [T1].[_IDRRef], [T1].[_Description] 1004 0,0068287 0,0012614 52 0,0080901 [T1].[_IDRRef], [T1].[_Description] PLAN_ROW 0 1 9057 1 |--Clustered Index Scan(OBJECT:([TestBase83].[dbo].[_AccumRg18].[_AccumRg18_ByPeriod_TRN] AS [T2])) 0 3 1 Clustered Index Scan Clustered Index Scan OBJECT:([TestBase83].[dbo].[_AccumRg18].[_AccumRg18_ByPeriod_TRN] AS [T2]) [T2].[_Fld20RRef] 9057 0,0912731 0,0101197 23 0,101393 [T2].[_Fld20RRef] PLAN_ROW 0 1