add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
Msg 208 Level 16 State 1 Line 1
Invalid object name 'docs'.
Msg 208 Level 16 State 1 Line 5
Invalid object name 'docs'.
Msg 208 Level 16 State 1 Line 6
Invalid object name 'docs'.
Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
1048576 1 with
  p0(i) as (select 1 union all select 1 union all select 1 union all select 1)
, p1(i) as (select 1 from p0 as a, p0 as b, p0 as c, p0 as d, p0 as e)--1K rows
, p2(i) as (select 1 from p1 as a, p1 as b)--1M rows
select row_number() over(order by i) as val
into integers
from p2
1 1 0 null null null null 1048576 null null null 21.37179 null null SELECT INTO False null
1048576 1   |--Table Insert(OBJECT:([integers]), SET:([integers].[val] = [Expr1056])) 1 2 1 Table Insert Insert OBJECT:([integers]), SET:([integers].[val] = [Expr1056]) null 1048576 12.97622 1.048576 9 21.37179 null null PLAN_ROW False 1
1048576 1        |--Sequence Project(DEFINE:([Expr1056]=row_number)) 1 3 2 Sequence Project Compute Scalar DEFINE:([Expr1056]=row_number) [Expr1056]=row_number 1048576 0 0.08388608 15 7.347001 [Expr1056] null PLAN_ROW False 1
1048576 1             |--Segment 1 4 3 Segment Segment null null 1048576 0 0.02097152 15 7.263114 [Segment1057] null PLAN_ROW False 1
1048576 1                  |--Nested Loops(Inner Join) 1 5 4 Nested Loops Inner Join null null 1048576 0 4.383048 9 7.242143 null NO JOIN PREDICATE PLAN_ROW False 1
262144 1                       |--Nested Loops(Inner Join) 1 6 5 Nested Loops Inner Join null null 262144 0 1.095762 9 1.810519 null NO JOIN PREDICATE PLAN_ROW False 1
65536 1                       | |--Nested Loops(Inner Join) 1 7 6 Nested Loops Inner Join null null 65536 0 0.2739405 9 0.4526129 null NO JOIN PREDICATE PLAN_ROW False 1
16384 1                       | | |--Nested Loops(Inner Join) 1 8 7 Nested Loops Inner Join null null 16384 0 0.06848512 9 0.1131363 null NO JOIN PREDICATE PLAN_ROW False 1
4096 1                       | | | |--Nested Loops(Inner Join) 1 9 8 Nested Loops Inner Join null null 4096 0 0.01712128 9 0.02826702 null NO JOIN PREDICATE PLAN_ROW False 1
1024 1                       | | | | |--Nested Loops(Inner Join) 1 10 9 Nested Loops Inner Join null null 1024 0 0.00428032 9 0.007049585 null NO JOIN PREDICATE PLAN_ROW False 1
256 1                       | | | | | |--Nested Loops(Inner Join) 1 11 10 Nested Loops Inner Join null null 256 0 0.00107008 9 0.001745108 null NO JOIN PREDICATE PLAN_ROW False 1
64 1                       | | | | | | |--Nested Loops(Inner Join) 1 12 11 Nested Loops Inner Join null null 64 0 0.00026752 9 0.000418871 null NO JOIN PREDICATE PLAN_ROW False 1
16 1                       | | | | | | | |--Nested Loops(Inner Join) 1 13 12 Nested Loops Inner Join null null 16 0 6.688E-05 9 8.7194E-05 null NO JOIN PREDICATE PLAN_ROW False 1
4 1                       | | | | | | | | |--Constant Scan 1 14 13 Constant Scan Constant Scan null null 4 0 4.157E-06 9 4.157E-06 null null PLAN_ROW False 1
16 4                       | | | | | | | | |--Constant Scan 1 15 13 Constant Scan Constant Scan null null 4 0 4.157E-06 9 1.6157E-05 null null PLAN_ROW False 4
64 16                       | | | | | | | |--Constant Scan 1 16 12 Constant Scan Constant Scan null null 4 0 4.157E-06 9 6.4157E-05 null null PLAN_ROW False 16
256 64                       | | | | | | |--Constant Scan 1 17 11 Constant Scan Constant Scan null null 4 0 4.157E-06 9 6.4157E-05 null null PLAN_ROW False 16
1024 256                       | | | | | |--Constant Scan 1 18 10 Constant Scan Constant Scan null null 4 0 4.157E-06 9 0.001024157 null null PLAN_ROW False 256
4096 1024                       | | | | |--Constant Scan 1 19 9 Constant Scan Constant Scan null null 4 0 4.157E-06 9 0.001024157 null null PLAN_ROW False 256
16384 4096                       | | | |--Constant Scan 1 20 8 Constant Scan Constant Scan null null 4 0 4.157E-06 9 0.01638416 null null PLAN_ROW False 4096
65536 16384                       | | |--Constant Scan 1 21 7 Constant Scan Constant Scan null null 4 0 4.157E-06 9 0.01638416 null null PLAN_ROW False 4096
262144 65536                       | |--Constant Scan 1 22 6 Constant Scan Constant Scan null null 4 0 4.157E-06 9 0.2621441 null null PLAN_ROW False 65536
1048576 262144                       |--Constant Scan 1 23 5 Constant Scan Constant Scan null null 4 0 4.157E-06 9 0.2621441 null null PLAN_ROW False 65536
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.8" Build="14.0.3015.40"><BatchSequence><Batch><Statements><StmtSimple StatementText="with&#xa; p0(i) as (select 1 union all select 1 union all select 1 union all select 1)&#xa;, p1(i) as (select 1 from p0 as a, p0 as b, p0 as c, p0 as d, p0 as e)--1K rows&#xa;, p2(i) as (select 1 from p1 as a, p1 as b)--1M rows&#xa;select row_number() over(order by i) as val&#xa;into integers&#xa;from p2" StatementId="2" StatementCompId="1" StatementType="SELECT INTO" RetrievedFromCache="true" StatementSubTreeCost="21.3718" StatementEstRows="1.04858e+006" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xB127C3F292E989BD" QueryPlanHash="0xDCAB1E2C8C1285C0" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="64" CompileTime="0" CompileCPU="0" CompileMemory="1072"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1515960"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><WaitStats><Wait WaitType="PREEMPTIVE_OS_FLUSHFILEBUFFERS" WaitTimeMs="15" WaitCount="1"></Wait></WaitStats><QueryTimeStats ElapsedTime="437" CpuTime="437"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="1.04858e+006" EstimateIO="12.9762" EstimateCPU="1.04858" AvgRowSize="9" EstimatedTotalSubtreeCost="21.3718" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1048576" Batches="0" ActualExecutionMode="Row" ActualElapsedms="421" ActualCPUms="421" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Table="[integers]" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[integers].[val] = [Expr1056]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[integers]" Column="val"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1056"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="1.04858e+006" EstimateIO="0" EstimateCPU="0.0838861" AvgRowSize="15" EstimatedTotalSubtreeCost="7.347" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1056"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1048576" Batches="0" ActualExecutionMode="Row" ActualElapsedms="234" ActualCPUms="234" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1056"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1.04858e+006" EstimateIO="0" EstimateCPU="0.0209715" AvgRowSize="15" EstimatedTotalSubtreeCost="7.26311" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Segment1057"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1048576" Batches="0" ActualExecutionMode="Row" ActualElapsedms="156" ActualCPUms="156" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1057"></ColumnReference></SegmentColumn><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.04858e+006" EstimateIO="0" EstimateCPU="4.38305" AvgRowSize="9" EstimatedTotalSubtreeCost="7.24214" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1048576" Batches="0" ActualExecutionMode="Row" ActualElapsedms="125" ActualCPUms="125" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="262144" EstimateIO="0" EstimateCPU="1.09576" AvgRowSize="9" EstimatedTotalSubtreeCost="1.81052" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="262144" Batches="0" ActualExecutionMode="Row" ActualElapsedms="78" ActualCPUms="78" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="65536" EstimateIO="0" EstimateCPU="0.27394" AvgRowSize="9" EstimatedTotalSubtreeCost="0.452613" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="65536" Batches="0" ActualExecutionMode="Row" ActualElapsedms="31" ActualCPUms="31" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="16384" EstimateIO="0" EstimateCPU="0.0684851" AvgRowSize="9" EstimatedTotalSubtreeCost="0.113136" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="16384" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="7" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4096" EstimateIO="0" EstimateCPU="0.0171213" AvgRowSize="9" EstimatedTotalSubtreeCost="0.028267" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4096" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1024" EstimateIO="0" EstimateCPU="0.00428032" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00704959" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1024" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="9" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="256" EstimateIO="0" EstimateCPU="0.00107008" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00174511" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="256" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="10" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="64" EstimateIO="0" EstimateCPU="0.00026752" AvgRowSize="9" EstimatedTotalSubtreeCost="0.000418871" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="64" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="11" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="16" EstimateIO="0" EstimateCPU="6.688e-005" AvgRowSize="9" EstimatedTotalSubtreeCost="8.7194e-005" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="16" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="12" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="4.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp><RelOp NodeId="13" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="1.6157e-005" Parallel="0" EstimateRebinds="0" EstimateRewinds="3" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="16" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="14" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="6.4157e-005" Parallel="0" EstimateRebinds="0" EstimateRewinds="15" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="64" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="16" ActualExecutions="16"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="15" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="6.4157e-005" Parallel="0" EstimateRebinds="0" EstimateRewinds="15" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="256" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="64" ActualExecutions="64"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="16" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00102416" Parallel="0" EstimateRebinds="0" EstimateRewinds="255" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1024" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="256" ActualExecutions="256"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="17" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00102416" Parallel="0" EstimateRebinds="0" EstimateRewinds="255" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4096" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1024" ActualExecutions="1024"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="18" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0163842" Parallel="0" EstimateRebinds="0" EstimateRewinds="4095" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="16384" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4096" ActualExecutions="4096"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="19" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0163842" Parallel="0" EstimateRebinds="0" EstimateRewinds="4095" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="65536" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="16384" ActualExecutions="16384"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="20" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.262144" Parallel="0" EstimateRebinds="0" EstimateRewinds="65535" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="262144" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="65536" ActualExecutions="65536"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="21" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="4" EstimateIO="0" EstimateCPU="4.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.262144" Parallel="0" EstimateRebinds="0" EstimateRewinds="65535" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1048576" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="262144" ActualExecutions="262144"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp></Segment></RelOp></SequenceProject></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>