Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions ---- -------- -------- ------ ------ ------ ---------- --------- -------- ------------- ------------ ---------- ----------- ---------- ---------------- ---------- -------- ---- -------- ------------------ 500 1 Top(TOP EXPRESSION:((500))) 0 0 Top Top TOP EXPRESSION:((500)) 5,38903 0 5,38903E-007 25 93,6708 [T1].[_Fld756], [T2].[_Fld756] PLAN_ROW 0 1 500 1 |--Hash Match(Inner Join, HASH:([T1].[_Fld757], [T1].[_Fld758])=([T2].[_Fld757], [T2].[_Fld758]), RESIDUAL:([Test].[dbo].[_InfoRg755].[_Fld757] as [T1].[_Fld757]=[Test].[dbo].[_InfoRg755].[_Fld757] as [T2].[_Fld757] AND [Test].[dbo].[_InfoRg755].[_Fld758] as [T1].[_Fld758]=[Test].[dbo].[_InfoRg755].[_Fld758] as [T2].[_Fld758])) 0 1 0 Hash Match Inner Join HASH:([T1].[_Fld757], [T1].[_Fld758])=([T2].[_Fld757], [T2].[_Fld758]), RESIDUAL:([Test].[dbo].[_InfoRg755].[_Fld757] as [T1].[_Fld757]=[Test].[dbo].[_InfoRg755].[_Fld757] as [T2].[_Fld757] AND [Test].[dbo].[_InfoRg755].[_Fld758] as [T1].[_Fld758]=[Test].[dbo].[_InfoRg755].[_Fld758] as [T2].[_Fld758]) 5,38903 0 78,1637 25 93,6708 [T1].[_Fld756], [T2].[_Fld756] PLAN_ROW 0 1 2010000 1 |--Index Scan(OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T1])) 0 2 1 Index Scan Index Scan OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T1]) [T1].[_Fld756], [T1].[_Fld757], [T1].[_Fld758] 2,01E+006 5,54238 2,21116 34 7,75354 [T1].[_Fld756], [T1].[_Fld757], [T1].[_Fld758] PLAN_ROW 0 1 500 1 |--Index Scan(OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T2])) 0 3 1 Index Scan Index Scan OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T2]) [T2].[_Fld756], [T2].[_Fld757], [T2].[_Fld758] 2,01E+006 5,54238 2,21116 34 7,75354 [T2].[_Fld756], [T2].[_Fld757], [T2].[_Fld758] PLAN_ROW 0 1