﻿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))                                                                                                                                                                                                                                                                                                                                                                                                   500          0            5E-005       25           18,4051          [T1].[_Q_001_F_000], [T2].[_Q_001_F_000]                                   PLAN_ROW     0            1                  
500          1              |--Hash Match(Inner Join, HASH:([T1].[_Q_001_F_001], [T1].[_Q_001_F_002])=([T2].[_Q_001_F_001], [T2].[_Q_001_F_002]), RESIDUAL:([tempdb].[dbo].[#tt2].[_Q_001_F_001] as [T1].[_Q_001_F_001]=[tempdb].[dbo].[#tt1].[_Q_001_F_001] as [T2].[_Q_001_F_001] AND [tempdb].[dbo].[#tt2].[_Q_001_F_002] as [T1].[_Q_001_F_002]=[tempdb].[dbo].[#tt1].[_Q_001_F_002] as [T2].[_Q_001_F_002])) 0            1            0            Hash Match   Inner Join   HASH:([T1].[_Q_001_F_001], [T1].[_Q_001_F_002])=([T2].[_Q_001_F_001], [T2].[_Q_001_F_002]), RESIDUAL:([tempdb].[dbo].[#tt2].[_Q_001_F_001] as [T1].[_Q_001_F_001]=[tempdb].[dbo].[#tt1].[_Q_001_F_001] as [T2].[_Q_001_F_001] AND [tempdb].[dbo].[#tt2].[_Q_001_F_002] as [T1].[_Q_001_F_002]=[tempdb].[dbo].[#tt1].[_Q_001_F_002] as [T2].[_Q_001_F_002])                                                               500          0            20,0042      25           18,4051          [T1].[_Q_001_F_000], [T2].[_Q_001_F_000]                                   PLAN_ROW     0            1                  
500000       1                   |--Table Scan(OBJECT:([tempdb].[dbo].[#tt2] AS [T1]))                                                                                                                                                                                                                                                                                                                            0            2            1            Table Scan   Table Scan   OBJECT:([tempdb].[dbo].[#tt2] AS [T1])                                                                                                                                                                                                                                                                                                                     [T1].[_Q_001_F_000], [T1].[_Q_001_F_001], [T1].[_Q_001_F_002] 500000       1,65646      0,550157     34           2,20662          [T1].[_Q_001_F_000], [T1].[_Q_001_F_001], [T1].[_Q_001_F_002]              PLAN_ROW     0            1                  
500          1                   |--Table Scan(OBJECT:([tempdb].[dbo].[#tt1] AS [T2]))                                                                                                                                                                                                                                                                                                                            0            3            1            Table Scan   Table Scan   OBJECT:([tempdb].[dbo].[#tt1] AS [T2])                                                                                                                                                                                                                                                                                                                     [T2].[_Q_001_F_000], [T2].[_Q_001_F_001], [T2].[_Q_001_F_002] 500          1,65646      0,550157     34           0,00548203       [T2].[_Q_001_F_000], [T2].[_Q_001_F_001], [T2].[_Q_001_F_002]              PLAN_ROW     0            1                  
