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 24,3707 [T1].[_Fld756], [T2].[_Fld756] PLAN_ROW 0 1 500 1 |--Parallelism(Gather Streams) 0 1 0 Parallelism Gather Streams 5,38903 0 0,0285033 25 24,3707 [T1].[_Fld756], [T2].[_Fld756] PLAN_ROW 1 6945 16 |--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 2 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]) 5,38903 0 9,786 25 24,3422 [T1].[_Fld756], [T2].[_Fld756] PLAN_ROW 1 2010000 16 |--Bitmap(HASH:([T1].[_Fld757], [T1].[_Fld758]), DEFINE:([Bitmap1004])) 0 3 2 Bitmap Bitmap Create HASH:([T1].[_Fld757], [T1].[_Fld758]) [Bitmap1004] 2,01E+006 0 1,45931 34 7,27808 [T1].[_Fld756], [T1].[_Fld757], [T1].[_Fld758] PLAN_ROW 1 2010000 16 | |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([T1].[_Fld757], [T1].[_Fld758])) 0 4 3 Parallelism Repartition Streams PARTITION COLUMNS:([T1].[_Fld757], [T1].[_Fld758]) 2,01E+006 0 1,45931 34 7,27808 [T1].[_Fld756], [T1].[_Fld757], [T1].[_Fld758] PLAN_ROW 1 2010000 16 | |--Index Scan(OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T1])) 0 5 4 Index Scan Index Scan OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T1]) [T1].[_Fld756], [T1].[_Fld757], [T1].[_Fld758] 2,01E+006 5,54238 0,276395 34 5,81878 [T1].[_Fld756], [T1].[_Fld757], [T1].[_Fld758] PLAN_ROW 1 6951 16 |--Parallelism(Repartition Streams, Hash Partitioning, PARTITION COLUMNS:([T2].[_Fld757], [T2].[_Fld758])) 0 6 2 Parallelism Repartition Streams PARTITION COLUMNS:([T2].[_Fld757], [T2].[_Fld758]) 2,01E+006 0 1,45931 34 7,27808 [T2].[_Fld756], [T2].[_Fld757], [T2].[_Fld758] PLAN_ROW 1 46065 16 |--Index Scan(OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T2]), WHERE:(PROBE([Bitmap1004],[Test].[dbo].[_InfoRg755].[_Fld757] as [T2].[_Fld757],[Test].[dbo].[_InfoRg755].[_Fld758] as [T2].[_Fld758]))) 0 7 6 Index Scan Index Scan OBJECT:([Test].[dbo].[_InfoRg755].[_InfoRg755_ByDims764_NNN] AS [T2]), WHERE:(PROBE([Bitmap1004],[Test].[dbo].[_InfoRg755].[_Fld757] as [T2].[_Fld757],[Test].[dbo].[_InfoRg755].[_Fld758] as [T2].[_Fld758])) [T2].[_Fld756], [T2].[_Fld757], [T2].[_Fld758] 2,01E+006 5,54238 0,276395 34 5,81878 [T2].[_Fld756], [T2].[_Fld757], [T2].[_Fld758] PLAN_ROW 1