SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.GraphNode 
(
    item character(1) NOT NULL PRIMARY KEY, 
        CONSTRAINT uq_node UNIQUE ($node_id)
) AS NODE;

CREATE TABLE dbo.GraphEdge 
(
    CONSTRAINT GraphEdge_GraphNode 
        CONNECTION (dbo.GraphNode TO dbo.GraphNode) 
        ON DELETE CASCADE,

    CONSTRAINT uq_edge 
        UNIQUE ($from_id, $to_id),
) AS EDGE;
INSERT dbo.GraphNode 
    (item)
VALUES 
    ('a'), ('b'), ('c'), 
    ('d'), ('e'), ('f'),
    ('g'), ('h');
8 rows affected

INSERT dbo.GraphEdge
    ($from_id, $to_id)
SELECT
    F.$node_id, T.$node_id
FROM 
(
    VALUES
        ('a', 'b'),
        ('b', 'c'),
        ('b', 'd'),
        ('e', 'f'),
        ('f', 'g'),
        ('g', 'h')
) AS V (from_item, to_item)
JOIN dbo.GraphNode AS F 
    ON F.item = V.from_item
JOIN dbo.GraphNode AS T 
    ON T.item = V.to_item;
    
6 rows affected

INSERT dbo.GraphEdge
    ($from_id, $to_id)
SELECT
    E.$to_id, E.$from_id 
FROM 
    dbo.GraphEdge AS E;
6 rows affected

set statistics xml on;

SELECT item,
       STRING_AGG(last_node, '->') WITHIN GROUP (ORDER BY last_node) AS closure
FROM
(
SELECT
    gn.item,
    LAST_VALUE(gn2.item) WITHIN GROUP (GRAPH PATH) AS last_node
FROM
    dbo.GraphNode AS gn WITH (FORCESEEK),
    dbo.GraphEdge FOR PATH AS ge,
    dbo.GraphNode FOR PATH AS gn2 WITH (FORCESEEK)
WHERE MATCH(SHORTEST_PATH(gn(-(ge)->gn2)+))
) AS t
GROUP BY item;


item
closure


a
a->b->c->d

b
a->b->c->d

c
a->b->c->d

d
a->b->c->d

e
e->f->g->h

f
e->f->g->h

g
e->f->g->h

h
e->f->g->h




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT item,&#xa;       STRING_AGG(last_node, &apos;-&gt;&apos;) WITHIN GROUP (ORDER BY last_node) AS closure&#xa;FROM&#xa;(&#xa;SELECT&#xa;    gn.item,&#xa;    LAST_VALUE(gn2.item) WITHIN GROUP (GRAPH PATH) AS last_node&#xa;FROM&#xa;    dbo.GraphNode AS gn WITH (FORCESEEK),&#xa;    dbo.GraphEdge FOR PATH AS ge,&#xa;    dbo.GraphNode FOR PATH AS gn2 WITH (FORCESEEK)&#xa;WHERE MATCH(SHORTEST_PATH(gn(-(ge)-&gt;gn2)+))&#xa;) AS t&#xa;GROUP BY item" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.688349" StatementEstRows="6.9282" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x8D374978B408FF61" QueryPlanHash="0x63D657BC8F36C2C3" StatementOptmEarlyAbortReason="TimeOut" CardinalityEstimationModelVersion="150"><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="120" CompileTime="15" CompileCPU="15" CompileMemory="2472"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="661944" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1108472"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2020-10-26T12:19:37.70" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000004_25869641]" Table="[GraphEdge]" Schema="[dbo]" Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]"></StatisticsInfo><StatisticsInfo LastUpdate="2020-10-26T12:19:37.70" ModificationCount="0" SamplingPercent="100" Statistics="[uq_node]" Table="[GraphNode]" Schema="[dbo]" Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]"></StatisticsInfo><StatisticsInfo LastUpdate="2020-10-26T12:19:37.69" ModificationCount="6" SamplingPercent="100" Statistics="[uq_edge]" Table="[GraphEdge]" Schema="[dbo]" Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]"></StatisticsInfo><StatisticsInfo LastUpdate="2020-10-26T12:19:37.70" ModificationCount="6" SamplingPercent="100" Statistics="[_WA_Sys_00000007_25869641]" Table="[GraphEdge]" Schema="[dbo]" Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]"></StatisticsInfo><StatisticsInfo LastUpdate="2020-10-26T12:19:37.69" ModificationCount="6" SamplingPercent="100" Statistics="[_WA_Sys_00000006_25869641]" Table="[GraphEdge]" Schema="[dbo]" Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]"></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><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="6.9282" EstimateIO="0" EstimateCPU="7.62102e-06" AvgRowSize="4012" EstimatedTotalSubtreeCost="0.688349" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference><ColumnReference Column="Expr1039"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1039"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphNode].[item] as [gn2].[item],&apos;-&gt;&apos;)WITHIN GROUP (ORDER BY [gn2].[item])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="item"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;-&gt;&apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference></GroupBy><RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="6.9282" EstimateIO="0.0112613" EstimateCPU="0.00013019" AvgRowSize="9" EstimatedTotalSubtreeCost="0.688342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="item"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="item"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="6.9282" EstimateIO="0" EstimateCPU="2.89599e-05" AvgRowSize="9" EstimatedTotalSubtreeCost="0.67695" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="item"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="6.9282" EstimateIO="0" EstimateCPU="2.89599e-05" AvgRowSize="16" EstimatedTotalSubtreeCost="0.672701" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></OuterReferences><RelOp NodeId="5" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="6.9282" EstimateIO="0" EstimateCPU="2.304e-05" AvgRowSize="23" EstimatedTotalSubtreeCost="0.668452" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="6" PhysicalOp="Sequence" LogicalOp="Sequence" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0230544" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0263566" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Sequence IsGraphDBTransitiveClosure="1" GraphSequenceIdentifier="0"><RelOp NodeId="7" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0038424" AvgRowSize="27" EstimatedTotalSubtreeCost="0.668429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="25" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Storage="RowStore" GraphWorkTableType="3" GraphWorkTableIdentifier="0"></Object><SetPredicate><ScalarOperator ScalarString="rec_DE313A0B622C4C7C99.[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[from_obj_id_222F9C88F41E4F22A7019A208E5D719E] as [ge].[from_obj_id_222F9C88F41E4F22A7019A208E5D719E],rec_DE313A0B622C4C7C99.[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[from_id_F9C3B92A3139427E854EF08A5BD6AE26] as [ge].[from_id_F9C3B92A3139427E854EF08A5BD6AE26],rec_DE313A0B622C4C7C99.[r_obj_id_21FFF8A67A954204ADA844D29768311F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A],rec_DE313A0B622C4C7C99.[r_id_E984129016794D6291A4152DA385F464] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939],rec_DE313A0B622C4C7C99.[rec_depth_5195D23BF2874D568D707AFC200C9624] = [Expr1002]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="8" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0038424" AvgRowSize="27" EstimatedTotalSubtreeCost="0.668429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="25" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Storage="RowStore" GraphWorkTableType="0" GraphWorkTableIdentifier="0"></Object><SetPredicate><ScalarOperator ScalarString="rec_DE313A0B622C4C.[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[from_obj_id_222F9C88F41E4F22A7019A208E5D719E] as [ge].[from_obj_id_222F9C88F41E4F22A7019A208E5D719E],rec_DE313A0B622C4C.[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[from_id_F9C3B92A3139427E854EF08A5BD6AE26] as [ge].[from_id_F9C3B92A3139427E854EF08A5BD6AE26],rec_DE313A0B622C4C.[r_obj_id_21FFF8A67A954204ADA844D29768311F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A],rec_DE313A0B622C4C.[r_id_E984129016794D6291A4152DA385F464] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939],rec_DE313A0B622C4C.[rec_depth_5195D23BF2874D568D707AFC200C9624] = [Expr1002]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[rec_DE313A0B622C4C]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="9" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0038424" AvgRowSize="27" EstimatedTotalSubtreeCost="0.668429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="25" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Storage="RowStore" GraphWorkTableType="2" GraphWorkTableIdentifier="0"></Object><SetPredicate><ScalarOperator ScalarString="rec_DE313A0B622C4C7C9.[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[from_obj_id_222F9C88F41E4F22A7019A208E5D719E] as [ge].[from_obj_id_222F9C88F41E4F22A7019A208E5D719E],rec_DE313A0B622C4C7C9.[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[from_id_F9C3B92A3139427E854EF08A5BD6AE26] as [ge].[from_id_F9C3B92A3139427E854EF08A5BD6AE26],rec_DE313A0B622C4C7C9.[to_obj_id_8153B3236A23480B9B627AD41C99370A] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A],rec_DE313A0B622C4C7C9.[to_id_AE67C6E16C3E436CA0E516702E3AE939] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939],rec_DE313A0B622C4C7C9.[64DC943A-158A-45F5-9E97-81A89DEE9905] = [Expr1002]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="64DC943A-158A-45F5-9E97-81A89DEE9905"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="12" EstimateIO="0" EstimateCPU="1.2e-06" AvgRowSize="35" EstimatedTotalSubtreeCost="0.00330216" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="12" EstimatedRowsRead="12" EstimateIO="0.003125" EstimateCPU="0.0001702" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0032952" TableCardinality="12" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="12" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Index="[uq_edge]" Alias="[ge]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(581577110)"><Const ConstValue="(581577110)"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A]=(581577110)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(581577110)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Update></RelOp></Update></RelOp></Update></RelOp><RelOp NodeId="12" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0038424" AvgRowSize="27" EstimatedTotalSubtreeCost="0.668429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="40" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Storage="RowStore" GraphWorkTableType="3" GraphWorkTableIdentifier="0"></Object><SetPredicate><ScalarOperator ScalarString="rec_DE313A0B622C4C7C99.[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] = [rec_DE313A0B622C4C7C996121B8B128CAD5].[l_obj_id_321D726CBAFD46F29CD032AD884B43A2],rec_DE313A0B622C4C7C99.[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] = [rec_DE313A0B622C4C7C996121B8B128CAD5].[l_id_FD1548D45BF04E6CAADAEAAC3D74902F],rec_DE313A0B622C4C7C99.[r_obj_id_21FFF8A67A954204ADA844D29768311F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A],rec_DE313A0B622C4C7C99.[r_id_E984129016794D6291A4152DA385F464] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939],rec_DE313A0B622C4C7C99.[rec_depth_5195D23BF2874D568D707AFC200C9624] = [Expr1009]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C99]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="13" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0038424" AvgRowSize="27" EstimatedTotalSubtreeCost="0.668429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="41" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_IterateNext]" Storage="RowStore" GraphWorkTableType="1" GraphWorkTableIdentifier="0"></Object><SetPredicate><ScalarOperator ScalarString="rec_DE313A0B622C4C7C9961.[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] = [rec_DE313A0B622C4C7C996121B8B128CAD5].[l_obj_id_321D726CBAFD46F29CD032AD884B43A2],rec_DE313A0B622C4C7C9961.[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] = [rec_DE313A0B622C4C7C996121B8B128CAD5].[l_id_FD1548D45BF04E6CAADAEAAC3D74902F],rec_DE313A0B622C4C7C9961.[r_obj_id_21FFF8A67A954204ADA844D29768311F] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A],rec_DE313A0B622C4C7C9961.[r_id_E984129016794D6291A4152DA385F464] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939],rec_DE313A0B622C4C7C9961.[rec_depth_5195D23BF2874D568D707AFC200C9624] = [Expr1009]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9961]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9961]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9961]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9961]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9961]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="14" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="48" EstimateIO="0" EstimateCPU="0.0038424" AvgRowSize="27" EstimatedTotalSubtreeCost="0.668429" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="40" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Storage="RowStore" GraphWorkTableType="2" GraphWorkTableIdentifier="0"></Object><SetPredicate><ScalarOperator ScalarString="rec_DE313A0B622C4C7C9.[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] = [rec_DE313A0B622C4C7C996121B8B128CAD5].[l_obj_id_321D726CBAFD46F29CD032AD884B43A2],rec_DE313A0B622C4C7C9.[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] = [rec_DE313A0B622C4C7C996121B8B128CAD5].[l_id_FD1548D45BF04E6CAADAEAAC3D74902F],rec_DE313A0B622C4C7C9.[to_obj_id_8153B3236A23480B9B627AD41C99370A] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_obj_id_8153B3236A23480B9B627AD41C99370A] as [ge].[to_obj_id_8153B3236A23480B9B627AD41C99370A],rec_DE313A0B622C4C7C9.[to_id_AE67C6E16C3E436CA0E516702E3AE939] = [fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939],rec_DE313A0B622C4C7C9.[64DC943A-158A-45F5-9E97-81A89DEE9905] = [Expr1009]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[rec_DE313A0B622C4C7C9]" Column="64DC943A-158A-45F5-9E97-81A89DEE9905"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="15" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="6.58417" EstimateIO="0.0112613" EstimateCPU="0.000157189" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0254971" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="20" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="16" PhysicalOp="Nested Loops" LogicalOp="Left Anti Semi Join" EstimateRows="10.7099" EstimateIO="0" EstimateCPU="0.000272564" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0140786" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total].[l_obj_id_321D726CBAFD46F29CD032AD884B43A2]=[rec_DE313A0B622C4C7C996121B8B128CAD5].[l_obj_id_321D726CBAFD46F29CD032AD884B43A2] AND [rec_DE313A0B622C4C7C996121B8B128CAD5_Total].[l_id_FD1548D45BF04E6CAADAEAAC3D74902F]=[rec_DE313A0B622C4C7C996121B8B128CAD5].[l_id_FD1548D45BF04E6CAADAEAAC3D74902F] AND [rec_DE313A0B622C4C7C996121B8B128CAD5_Total].[to_id_AE67C6E16C3E436CA0E516702E3AE939]=[fiddle_95937c959e0d4b6eb99f2c50a5f5c326].[dbo].[GraphEdge].[to_id_AE67C6E16C3E436CA0E516702E3AE939] as [ge].[to_id_AE67C6E16C3E436CA0E516702E3AE939]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="17" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="11.9059" EstimateIO="0" EstimateCPU="4.97666e-05" AvgRowSize="35" EstimatedTotalSubtreeCost="0.00781565" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="48" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></OuterReferences><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.93725" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00338164" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5].[rec_depth_5195D23BF2874D568D707AFC200C9624]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="3.024e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00338154" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="20" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="63" EstimatedRowsRead="63" EstimateIO="0.003125" EstimateCPU="0.0002263" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0033513" TableCardinality="63" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" TableReferenceId="1" Storage="RowStore" GraphWorkTableType="0" GraphWorkTableIdentifier="0"></Object></TableScan></RelOp><Predicate><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5].[r_obj_id_21FFF8A67A954204ADA844D29768311F]=(581577110)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(581577110)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp><RelOp NodeId="21" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.5" EstimatedRowsRead="1.5" EstimateIO="0.003125" EstimateCPU="0.00015865" AvgRowSize="19" EstimatedTotalSubtreeCost="0.00438425" TableCardinality="12" Parallel="0" EstimateRebinds="5.11994" EstimateRewinds="1.81731" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="48" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="32" ActualLogicalReads="64" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="48" ActualEndOfScans="32" ActualExecutions="32"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Index="[uq_edge]" Alias="[ge]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_obj_id_222F9C88F41E4F22A7019A208E5D719E"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="from_id_F9C3B92A3139427E854EF08A5BD6AE26"></ColumnReference><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphEdge]" Alias="[ge]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(581577110)"><Const ConstValue="(581577110)"></Const></ScalarOperator><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5].[r_id_E984129016794D6291A4152DA385F464]"><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(581577110)"><Const ConstValue="(581577110)"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="22" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="9.74679" EstimateIO="0" EstimateCPU="4.56e-05" AvgRowSize="27" EstimatedTotalSubtreeCost="0.00592518" Parallel="0" EstimateRebinds="0" EstimateRewinds="10.9059" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="517" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="24" ActualExecutions="48"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="23" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="95" EstimatedRowsRead="95" EstimateIO="0.0032035" EstimateCPU="0.000183" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00538228" TableCardinality="95" Parallel="0" EstimateRebinds="0" EstimateRewinds="10.9059" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="517" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="98" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="517" ActualEndOfScans="24" ActualExecutions="48"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_id_AE67C6E16C3E436CA0E516702E3AE939"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" TableReferenceId="2" Storage="RowStore" GraphWorkTableType="2" GraphWorkTableIdentifier="0"></Object></TableScan></RelOp><Predicate><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total].[to_obj_id_8153B3236A23480B9B627AD41C99370A]=(581577110)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Total]" Column="to_obj_id_8153B3236A23480B9B627AD41C99370A"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(581577110)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp></Sort></RelOp></Update></RelOp></Update></RelOp></Update></RelOp><RelOp NodeId="24" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0076848" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0076848" Parallel="0" EstimateRebinds="48" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="1" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_obj_id_21FFF8A67A954204ADA844D29768311F"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="rec_depth_5195D23BF2874D568D707AFC200C9624"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Storage="RowStore" GraphWorkTableType="3" GraphWorkTableIdentifier="0"></Object></TableScan></RelOp></Sequence></RelOp><Predicate><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results].[l_obj_id_321D726CBAFD46F29CD032AD884B43A2]=(581577110)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_obj_id_321D726CBAFD46F29CD032AD884B43A2"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(581577110)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="25" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00422035" TableCardinality="8" Parallel="0" EstimateRebinds="4.29606" EstimateRewinds="1.63215" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="64" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32" ActualEndOfScans="0" ActualExecutions="32"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="item"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Index="[uq_node]" Alias="[gn]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn]" Column="graph_id_A7DB65A5657D4E87AB41E220BEB77356"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results].[l_id_FD1548D45BF04E6CAADAEAAC3D74902F]"><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="l_id_FD1548D45BF04E6CAADAEAAC3D74902F"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="26" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00422035" TableCardinality="8" Parallel="0" EstimateRebinds="4.29606" EstimateRewinds="1.63215" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="item"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="32" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="64" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32" ActualEndOfScans="0" ActualExecutions="32"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="item"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Index="[uq_node]" Alias="[gn2]" TableReferenceId="3" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_95937c959e0d4b6eb99f2c50a5f5c326]" Schema="[dbo]" Table="[GraphNode]" Alias="[gn2]" Column="graph_id_A7DB65A5657D4E87AB41E220BEB77356"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results].[r_id_E984129016794D6291A4152DA385F464]"><Identifier><ColumnReference Table="[rec_DE313A0B622C4C7C996121B8B128CAD5_Results]" Column="r_id_E984129016794D6291A4152DA385F464"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Sort></RelOp></StreamAggregate></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
item	closure
a	a->b->c->d
b	a->b->c->d
c	a->b->c->d
d	a->b->c->d
e	e->f->g->h
f	e->f->g->h
g	e->f->g->h
h	e->f->g->h