By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| SubnetID | SubnetName | (No column name) |
|---|---|---|
| 1 | 1.2.3.0/24 | 1.2.3.0 |
| 1 | 1.2.3.0/24 | 1.2.3.1 |
| 1 | 1.2.3.0/24 | 1.2.3.2 |
| 1 | 1.2.3.0/24 | 1.2.3.3 |
| 1 | 1.2.3.0/24 | 1.2.3.4 |
| 1 | 1.2.3.0/24 | 1.2.3.5 |
| 1 | 1.2.3.0/24 | 1.2.3.6 |
| 1 | 1.2.3.0/24 | 1.2.3.7 |
| 1 | 1.2.3.0/24 | 1.2.3.8 |
| 1 | 1.2.3.0/24 | 1.2.3.9 |
| 1 | 1.2.3.0/24 | 1.2.3.10 |
| 1 | 1.2.3.0/24 | 1.2.3.11 |
| 1 | 1.2.3.0/24 | 1.2.3.12 |
| 1 | 1.2.3.0/24 | 1.2.3.13 |
| 1 | 1.2.3.0/24 | 1.2.3.14 |
| 1 | 1.2.3.0/24 | 1.2.3.15 |
| 1 | 1.2.3.0/24 | 1.2.3.16 |
| 1 | 1.2.3.0/24 | 1.2.3.17 |
| 1 | 1.2.3.0/24 | 1.2.3.18 |
| 1 | 1.2.3.0/24 | 1.2.3.19 |
| 1 | 1.2.3.0/24 | 1.2.3.20 |
| 1 | 1.2.3.0/24 | 1.2.3.21 |
| 1 | 1.2.3.0/24 | 1.2.3.22 |
| 1 | 1.2.3.0/24 | 1.2.3.23 |
| 1 | 1.2.3.0/24 | 1.2.3.24 |
| 2 | 1.2.4.0/14 | 1.2.4.0 |
| 2 | 1.2.4.0/14 | 1.2.4.1 |
| 2 | 1.2.4.0/14 | 1.2.4.2 |
| 2 | 1.2.4.0/14 | 1.2.4.3 |
| 2 | 1.2.4.0/14 | 1.2.4.4 |
| 2 | 1.2.4.0/14 | 1.2.4.5 |
| 2 | 1.2.4.0/14 | 1.2.4.6 |
| 2 | 1.2.4.0/14 | 1.2.4.7 |
| 2 | 1.2.4.0/14 | 1.2.4.8 |
| 2 | 1.2.4.0/14 | 1.2.4.9 |
| 2 | 1.2.4.0/14 | 1.2.4.10 |
| 2 | 1.2.4.0/14 | 1.2.4.11 |
| 2 | 1.2.4.0/14 | 1.2.4.12 |
| 2 | 1.2.4.0/14 | 1.2.4.13 |
| 2 | 1.2.4.0/14 | 1.2.4.14 |
| 3 | 1.2.5.4/30 | 1.2.5.4 |
| 3 | 1.2.5.4/30 | 1.2.5.5 |
| 3 | 1.2.5.4/30 | 1.2.5.6 |
| 3 | 1.2.5.4/30 | 1.2.5.7 |
| 3 | 1.2.5.4/30 | 1.2.5.8 |
| 3 | 1.2.5.4/30 | 1.2.5.9 |
| 3 | 1.2.5.4/30 | 1.2.5.10 |
| 3 | 1.2.5.4/30 | 1.2.5.11 |
| 3 | 1.2.5.4/30 | 1.2.5.12 |
| 3 | 1.2.5.4/30 | 1.2.5.13 |
| 3 | 1.2.5.4/30 | 1.2.5.14 |
| 3 | 1.2.5.4/30 | 1.2.5.15 |
| 3 | 1.2.5.4/30 | 1.2.5.16 |
| 3 | 1.2.5.4/30 | 1.2.5.17 |
| 3 | 1.2.5.4/30 | 1.2.5.18 |
| 3 | 1.2.5.4/30 | 1.2.5.19 |
| 3 | 1.2.5.4/30 | 1.2.5.20 |
| 3 | 1.2.5.4/30 | 1.2.5.21 |
| 3 | 1.2.5.4/30 | 1.2.5.22 |
| 3 | 1.2.5.4/30 | 1.2.5.23 |
| 3 | 1.2.5.4/30 | 1.2.5.24 |
| 3 | 1.2.5.4/30 | 1.2.5.25 |
| 3 | 1.2.5.4/30 | 1.2.5.26 |
| 3 | 1.2.5.4/30 | 1.2.5.27 |
| 3 | 1.2.5.4/30 | 1.2.5.28 |
| 3 | 1.2.5.4/30 | 1.2.5.29 |
| 3 | 1.2.5.4/30 | 1.2.5.30 |
Warning: Null value is eliminated by an aggregate or other SET operation.
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.481" Build="14.0.3451.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="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" 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="15" CompileCPU="15" CompileMemory="1072"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="719904"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><WaitStats><Wait WaitType="MEMORY_ALLOCATION_EXT" WaitTimeMs="15" WaitCount="4159"></Wait><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="29" WaitCount="199"></Wait><Wait WaitType="PREEMPTIVE_OS_FLUSHFILEBUFFERS" WaitTimeMs="134" WaitCount="2"></Wait></WaitStats><QueryTimeStats ElapsedTime="968" CpuTime="968"></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="876" ActualCPUms="876" 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="264" ActualCPUms="264" 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="123" ActualCPUms="123" 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="123" ActualCPUms="123" 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="15" ActualCPUms="15" 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="15" ActualCPUms="15" 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="15" ActualCPUms="15" 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="15" ActualCPUms="15" 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="0" ActualCPUms="0" 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="0" ActualCPUms="0" 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="14" ActualCPUms="14" ActualEndOfScans="262144" ActualExecutions="262144"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp></Segment></RelOp></SequenceProject></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |