By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE FUNCTION dbo.splitstring (@inputStr VARCHAR(MAX),@spitChar varchar(1))
RETURNS
@returnList TABLE ([Value] [nvarchar] (500))
AS
BEGIN
DECLARE @name NVARCHAR(255)
DECLARE @pos INT
WHILE CHARINDEX(@spitChar, @inputStr) > 0
BEGIN
SELECT @pos = CHARINDEX(@spitChar, @inputStr)
SELECT @name = SUBSTRING(@inputStr, 1, @pos-1)
INSERT INTO @returnList
SELECT @name
SELECT @inputStr = SUBSTRING(@inputStr, @pos+1, LEN(@inputStr)-@pos)
END
INSERT INTO @returnList
SELECT @inputStr
RETURN
END
CREATE TABLE T(
SubnetID INT,
SubnetName VARCHAR(50)
);
INSERT INTO T VALUES (1,'1.2.3.0/24');
INSERT INTO T VALUES (2,'1.2.4.0/14');
INSERT INTO T VALUES (3,'1.2.5.4/30');
;WITH CTE AS (
SELECT t1.SubnetID,
t1.SubnetName,
MAX(CASE WHEN rn = 1 THEN v.value END) startIP,
MAX(CASE WHEN rn = 2 THEN v.value END) MaxLevel
FROM T t1
CROSS APPLY (SELECT value,row_number() over (order by (select null)) rn FROM splitstring(t1.SubnetName,'/')) v
GROUP BY t1.SubnetName,
t1.SubnetID
),CTE1 AS(
SELECT
t1.SubnetID,
t1.SubnetName,
t1.startIP,
CAST(t1.MaxLevel AS INT) MaxLevel,
CAST(MAX(CASE WHEN rn = 4 THEN v.value END) AS INT) StartLevel,
CAST(MAX(CASE WHEN rn = 4 THEN v.value END) AS INT) IPSub
FROM CTE t1
CROSS APPLY (SELECT value,row_number() over (order by (select null)) rn FROM splitstring(t1.startIP,'.')) v
GROUP BY
t1.SubnetName,
t1.startIP,
t1.MaxLevel,
t1.SubnetID
UNION ALL
SELECT
| 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.
--------------------------------------------------------------------------------
-- ① Execution Plans
--------------------------------------------------------------------------------
set statistics profile on;
select max('Do this to get execution plans and stats') "Execution Plans"
from docs d1 cross join docs d2;
set statistics profile off;
Msg 208 Level 16 State 1 Line 5
Invalid object name 'docs'.
--------------------------------------------------------------------------------
-- Or use XML to see the visual representation, thanks to Justin Pealing and
-- his library: https://github.com/JustinPealing/html-query-plan
--------------------------------------------------------------------------------
set statistics xml on;
select max('Do this to get execution plans and stats') "Execution Plans"
from docs d1 cross join docs d2;
set statistics xml off;
Msg 208 Level 16 State 1 Line 6
Invalid object name 'docs'.
--------------------------------------------------------------------------------
-- ② Integers table
--------------------------------------------------------------------------------
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
| 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> |
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
SELECT INTO
SELECT INTO
| Cached plan size | 64 KB |
|---|---|
| Estimated Operator Cost | 0 (0%) |
| Estimated Subtree Cost | 21.3718 |
| Degree of Parallelism | 0 |
| Estimated Number of Rows | 1.04858e+006 |
Statement
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
Table Insert
(Insert)
Cost: 66%
Table Insert
Insert input rows into the table specified in Argument field.
| Physical Operation | Table Insert |
|---|---|
| Logical Operation | Insert |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1048576 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 14.0248 (66%) |
| Estimated I/O Cost | 12.9762 |
| Estimated CPU Cost | 1.04858 |
| Estimated Subtree Cost | 21.3718 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.04858e+006 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 0 |
Object
[integers]
Predicate
[integers].[val] = [Expr1056]
Sequence Project
(Compute Scalar)
Cost: 0%
Sequence Project
| Physical Operation | Sequence Project |
|---|---|
| Logical Operation | Compute Scalar |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1048576 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.08389 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0838861 |
| Estimated Subtree Cost | 7.347 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.04858e+006 |
| Estimated Row Size | 15 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 1 |
Output List
Expr1056
Segment
Cost: 0%
Segment
| Physical Operation | Segment |
|---|---|
| Logical Operation | Segment |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1048576 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.02097 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0209715 |
| Estimated Subtree Cost | 7.26311 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.04858e+006 |
| Estimated Row Size | 15 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 2 |
Output List
Segment1057
Nested Loops
(Inner Join)
Cost: 24%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1048576 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 5.169476 (24%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 4.38305 |
| Estimated Subtree Cost | 7.24214 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.04858e+006 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 3 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 5%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 262144 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 1.095763 (5%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.09576 |
| Estimated Subtree Cost | 1.81052 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 262144 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 4 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 2%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 65536 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.3230928 (2%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.27394 |
| Estimated Subtree Cost | 0.452613 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 65536 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 5 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 16384 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0684848 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0684851 |
| Estimated Subtree Cost | 0.113136 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 16384 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 6 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 4096 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0201933 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0171213 |
| Estimated Subtree Cost | 0.028267 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 4096 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 7 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1024 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0042803 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0042803 |
| Estimated Subtree Cost | 0.0070496 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1024 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 8 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 256 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0012621 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0010701 |
| Estimated Subtree Cost | 0.0017451 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 256 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 9 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 64 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0002675 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0002675 |
| Estimated Subtree Cost | 0.0004189 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 64 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 10 |
Warnings
No Join Predicate
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 16 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000669 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000669 |
| Estimated Subtree Cost | 0.0000872 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 16 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 11 |
Warnings
No Join Predicate
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 4 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000042 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0000042 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 12 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 16 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000162 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0000162 |
| Estimated Number of Executions | 1 |
| Number of Executions | 4 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 13 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 64 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000642 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0000642 |
| Estimated Number of Executions | 1 |
| Number of Executions | 16 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 14 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 256 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000642 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0000642 |
| Estimated Number of Executions | 1 |
| Number of Executions | 64 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 15 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1024 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0010242 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0010242 |
| Estimated Number of Executions | 1 |
| Number of Executions | 256 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 16 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 4096 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0010242 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0010242 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1024 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 17 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 16384 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0163842 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0163842 |
| Estimated Number of Executions | 1 |
| Number of Executions | 4096 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 18 |
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 65536 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0163842 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.0163842 |
| Estimated Number of Executions | 1 |
| Number of Executions | 16384 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 19 |
Constant Scan
Cost: 1%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 262144 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.262144 (1%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.262144 |
| Estimated Number of Executions | 1 |
| Number of Executions | 65536 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 20 |
Constant Scan
Cost: 1%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 1048576 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.262144 (1%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000042 |
| Estimated Subtree Cost | 0.262144 |
| Estimated Number of Executions | 1 |
| Number of Executions | 262144 |
| Estimated Number of Rows | 4 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 21 |