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.
Execution Plans
Do this to get execution plans and stats
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="select max(&apos;Do this to get execution plans and stats&apos;) &quot;Execution Plans&quot;" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x0900860B55C1D06561B6D7059D85B54773D70000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="2.257e-06" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF4DF73A4D01C304E" QueryPlanHash="0xC5C97FFE9898E08F" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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="16" CompileTime="15" CompileCPU="0" CompileMemory="304"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1236336"></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><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="31" EstimatedTotalSubtreeCost="2.257e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1000"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1000"></ColumnReference><ScalarOperator ScalarString="MAX(&apos;Do this to get execution plans and stats&apos;)"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Const ConstValue="&apos;Do this to get execution plans and stats&apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="1.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></StreamAggregate></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="INSERT INTO #edges(tail,head) VALUES&#xa; (0,1), (5, 6), (10,11), (15,16), (20,21), (25,26),&#xa; (0,2), (5, 7), (10,12), (15,17), (20,22), (25,27),&#xa; (1,2), (6, 7), (11,12), (16,17), (21,22), (26,27),&#xa; (1,3), (7, 8), (11,13), (17,18), (21,23), (27,28),&#xa; (2,3), (7, 9), (12,13), (17,19), (22,23),&#xa; (2,4), (8, 9), (12,14), (18,19), (22,24),&#xa; (3,4), (8,10), (13,14), (18,20), (23,24),&#xa; (3,5), (9,10), (13,15), (19,20), (23,25),&#xa; (4,5), (9,11), (14,15), (19,21), (24,25),&#xa; (4,6), (14,16), (24,26)" StatementId="2" StatementCompId="5" StatementType="INSERT" StatementSqlHandle="0x0900A41F553C17E97DEE80055631C48F13660000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" BatchSqlHandle="0x0200000030439F292BFE1FD03F305DD8D4F595D32A6C50A60000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0101042" StatementEstRows="52" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0xB045C843575671DD" QueryPlanHash="0xA72C60E34323EDA2" CardinalityEstimationModelVersion="160"><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="56" CompileTime="0" CompileCPU="0" CompileMemory="784"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1236336"></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><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="52" EstimateIO="0.01" EstimateCPU="5.2e-05" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0101042" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="52" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="52" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Schema="[dbo]" Table="[#edges]" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[#edges].[tail] = [Union1107],[#edges].[head] = [Union1108]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[#edges]" Column="tail"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Union1107"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[#edges]" Column="head"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Union1108"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="52" EstimateIO="0" EstimateCPU="5.2157e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="5.2157e-05" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1107"></ColumnReference><ColumnReference Column="Union1108"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="52" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator><ScalarOperator ScalarString="(6)"><Const ConstValue="(6)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(10)"><Const ConstValue="(10)"></Const></ScalarOperator><ScalarOperator ScalarString="(11)"><Const ConstValue="(11)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(15)"><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator ScalarString="(16)"><Const ConstValue="(16)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(20)"><Const ConstValue="(20)"></Const></ScalarOperator><ScalarOperator ScalarString="(21)"><Const ConstValue="(21)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(25)"><Const ConstValue="(25)"></Const></ScalarOperator><ScalarOperator ScalarString="(26)"><Const ConstValue="(26)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(10)"><Const ConstValue="(10)"></Const></ScalarOperator><ScalarOperator ScalarString="(12)"><Const ConstValue="(12)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(15)"><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator ScalarString="(17)"><Const ConstValue="(17)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(20)"><Const ConstValue="(20)"></Const></ScalarOperator><ScalarOperator ScalarString="(22)"><Const ConstValue="(22)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(25)"><Const ConstValue="(25)"></Const></ScalarOperator><ScalarOperator ScalarString="(27)"><Const ConstValue="(27)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(6)"><Const ConstValue="(6)"></Const></ScalarOperator><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(11)"><Const ConstValue="(11)"></Const></ScalarOperator><ScalarOperator ScalarString="(12)"><Const ConstValue="(12)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(16)"><Const ConstValue="(16)"></Const></ScalarOperator><ScalarOperator ScalarString="(17)"><Const ConstValue="(17)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(21)"><Const ConstValue="(21)"></Const></ScalarOperator><ScalarOperator ScalarString="(22)"><Const ConstValue="(22)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(26)"><Const ConstValue="(26)"></Const></ScalarOperator><ScalarOperator ScalarString="(27)"><Const ConstValue="(27)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator><ScalarOperator ScalarString="(8)"><Const ConstValue="(8)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(11)"><Const ConstValue="(11)"></Const></ScalarOperator><ScalarOperator ScalarString="(13)"><Const ConstValue="(13)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(17)"><Const ConstValue="(17)"></Const></ScalarOperator><ScalarOperator ScalarString="(18)"><Const ConstValue="(18)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(21)"><Const ConstValue="(21)"></Const></ScalarOperator><ScalarOperator ScalarString="(23)"><Const ConstValue="(23)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(27)"><Const ConstValue="(27)"></Const></ScalarOperator><ScalarOperator ScalarString="(28)"><Const ConstValue="(28)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(12)"><Const ConstValue="(12)"></Const></ScalarOperator><ScalarOperator ScalarString="(13)"><Const ConstValue="(13)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(17)"><Const ConstValue="(17)"></Const></ScalarOperator><ScalarOperator ScalarString="(19)"><Const ConstValue="(19)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(22)"><Const ConstValue="(22)"></Const></ScalarOperator><ScalarOperator ScalarString="(23)"><Const ConstValue="(23)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(8)"><Const ConstValue="(8)"></Const></ScalarOperator><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(12)"><Const ConstValue="(12)"></Const></ScalarOperator><ScalarOperator ScalarString="(14)"><Const ConstValue="(14)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(18)"><Const ConstValue="(18)"></Const></ScalarOperator><ScalarOperator ScalarString="(19)"><Const ConstValue="(19)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(22)"><Const ConstValue="(22)"></Const></ScalarOperator><ScalarOperator ScalarString="(24)"><Const ConstValue="(24)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(8)"><Const ConstValue="(8)"></Const></ScalarOperator><ScalarOperator ScalarString="(10)"><Const ConstValue="(10)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(13)"><Const ConstValue="(13)"></Const></ScalarOperator><ScalarOperator ScalarString="(14)"><Const ConstValue="(14)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(18)"><Const ConstValue="(18)"></Const></ScalarOperator><ScalarOperator ScalarString="(20)"><Const ConstValue="(20)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(23)"><Const ConstValue="(23)"></Const></ScalarOperator><ScalarOperator ScalarString="(24)"><Const ConstValue="(24)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator><ScalarOperator ScalarString="(10)"><Const ConstValue="(10)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(13)"><Const ConstValue="(13)"></Const></ScalarOperator><ScalarOperator ScalarString="(15)"><Const ConstValue="(15)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(19)"><Const ConstValue="(19)"></Const></ScalarOperator><ScalarOperator ScalarString="(20)"><Const ConstValue="(20)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(23)"><Const ConstValue="(23)"></Const></ScalarOperator><ScalarOperator ScalarString="(25)"><Const ConstValue="(25)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator><ScalarOperator ScalarString="(11)"><Const ConstValue="(11)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(14)"><Const ConstValue="(14)"></Const></ScalarOperator><ScalarOperator ScalarString="(15)"><Const ConstValue="(15)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(19)"><Const ConstValue="(19)"></Const></ScalarOperator><ScalarOperator ScalarString="(21)"><Const ConstValue="(21)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(24)"><Const ConstValue="(24)"></Const></ScalarOperator><ScalarOperator ScalarString="(25)"><Const ConstValue="(25)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator ScalarString="(6)"><Const ConstValue="(6)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(14)"><Const ConstValue="(14)"></Const></ScalarOperator><ScalarOperator ScalarString="(16)"><Const ConstValue="(16)"></Const></ScalarOperator></Row><Row><ScalarOperator ScalarString="(24)"><Const ConstValue="(24)"></Const></ScalarOperator><ScalarOperator ScalarString="(26)"><Const ConstValue="(26)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
node
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH descendents(node)&#xa;AS(&#xa; SELECT 0 as node&#xa; UNION ALL&#xa; SELECT head as node FROM descendents as prior&#xa; JOIN #edges ON prior.node = tail&#xa;)&#xa;SELECT DISTINCT&#xa; node&#xa;FROM descendents" StatementId="3" StatementCompId="6" StatementType="SELECT" StatementSqlHandle="0x0900F32E78D758F9FF7283761825028274DA0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" BatchSqlHandle="0x0200000030439F292BFE1FD03F305DD8D4F595D32A6C50A60000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0158105" StatementEstRows="2.56348" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x6645CF0060D310B3" QueryPlanHash="0x17945AB491D2E30C" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="32" CompileTime="0" CompileCPU="0" CompileMemory="224"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="784128" GrantedMemory="1024" MaxUsedMemory="1024"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1236336"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-05-20T01:06:06.14" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_A732BD40]" Table="[#edges______________________________________________________________________________________________________________000000000481]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo></OptimizerStatsUsage><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="PAGELATCH_SH" WaitTimeMs="3708" WaitCount="436644"></Wait><Wait WaitType="PAGELATCH_EX" WaitTimeMs="922" WaitCount="166340"></Wait></WaitStats><QueryTimeStats ElapsedTime="19499" CpuTime="15608"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="2.56348" EstimateIO="0.0112613" EstimateCPU="0.000127856" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0158105" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1005"></ColumnReference></OutputList><Warnings><SpillToTempDb SpillLevel="2" SpilledThreadCount="1"></SpillToTempDb><SortSpillDetails GrantedMemoryKb="1024" UsedMemoryKb="1024" WritesToTempDb="47" ReadsFromTempDb="47"></SortSpillDetails></Warnings><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="19499" ActualCPUms="15608" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="47" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="1024" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Recr1005"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Index Spool" LogicalOp="Lazy Spool" EstimateRows="6.57143" EstimateIO="0" EstimateCPU="1.42857e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00442137" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="602985" Batches="0" ActualElapsedms="18640" ActualCPUms="14748" ActualScans="1" ActualLogicalReads="1205971" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool Stack="1"><RelOp NodeId="2" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="6.57143" EstimateIO="0" EstimateCPU="2.85714e-09" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00426069" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Recr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="602985" Batches="0" ActualElapsedms="9651" ActualCPUms="9651" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1005"></ColumnReference><ColumnReference Column="Expr1000"></ColumnReference><ColumnReference Table="[#edges]" Column="head"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="2.85714e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="2.85714e-08" Parallel="0" EstimateRebinds="6.57143" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1000"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1000"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="5" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="6.57143" EstimateIO="0" EstimateCPU="2.4e-07" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00425953" Parallel="0" EstimateRebinds="6.57143" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Table="[#edges]" Column="head"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="602984" Batches="0" ActualElapsedms="9589" ActualCPUms="9589" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Assert StartupExpression="0"><RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="6.57143" EstimateIO="0" EstimateCPU="2.4e-07" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00425953" Parallel="0" EstimateRebinds="6.57143" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Table="[#edges]" Column="head"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="602984" Batches="0" ActualElapsedms="8729" ActualCPUms="8729" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Recr1001"></ColumnReference></OuterReferences><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="2.85714e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="2.85714e-08" Parallel="0" EstimateRebinds="6.57143" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Recr1001"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="[Expr1007]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="2.85714e-08" AvgRowSize="11" EstimatedTotalSubtreeCost="2.85714e-08" Parallel="0" EstimateRebinds="6.57143" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Recr1001"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="602985" Batches="0" ActualElapsedms="2979" ActualCPUms="2979" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="1" Stack="1"></Spool></RelOp></ComputeScalar></RelOp><RelOp NodeId="9" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1.85714" EstimatedRowsRead="52" EstimateIO="0.0032035" EstimateCPU="0.0001357" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00409524" TableCardinality="52" Parallel="0" EstimateRebinds="0" EstimateRewinds="5.57143" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[#edges]" Column="head"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="602984" Batches="0" ActualElapsedms="5624" ActualCPUms="5624" ActualScans="1" ActualLogicalReads="602985" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="31355220" ActualEndOfScans="602985" ActualExecutions="602985" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="[#edges]" Column="head"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#edges]" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[#edges].[tail]=[Recr1001]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[#edges]" Column="tail"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1001"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></TableScan></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1008]&gt;(100) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></Concat></RelOp></Spool></RelOp></Sort></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>