By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| (No column name) |
|---|
| [{"id":1,"text":"Category 1","path":"1","depth":1,"expanded":1,"children":[{"id":2,"text":"SubCategory 1","path":"1,2","depth":2,"expanded":1,"children":[{"id":3,"text":"Element 1","path":"1,2,3","depth":3},{"id":9,"text":"SubSubCategory 1","path":"1,2,9","depth":3}]}]},{"id":10,"text":"Category 3","path":"10","depth":1},{"id":4,"text":"Category 2","path":"4","depth":1,"expanded":1,"children":[{"id":5,"text":"SubCategory 2","path":"4,5","depth":2,"children":[{"id":8,"text":"SubElement 1","path":"4,5,8","depth":3}]},{"id":6,"text":"SubCategory 3","path":"4,6","depth":2},{"id":7,"text":"Element 2","path":"4,7","depth":2,"expanded":1}]}] |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4335.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH 
 Recursion AS
 (
 -- Anchor part
 SELECT 
 TT.id, 
 depth = 1,
 rpath = CONVERT(nvarchar(4000), TT.id),
 has_children = 
 IIF
 (
 EXISTS
 (
 SELECT C.* 
 FROM #tTree AS C 
 WHERE C.parentId = TT.id
 ), 
 1, 0
 ),
 element = 
 (
 SELECT 
 TT.id,
 TT.[text], 
 TT.[path], 
 TT.depth,
 TT.expanded
 FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
 )
 FROM #tTree AS TT
 WHERE TT.parentID IS NULL

 UNION ALL 

 -- Recursive part
 SELECT
 TT.id,
 depth = R.depth + 1,
 rpath = CONCAT_WS(N'.', R.rpath, TT.id),
 has_children = 
 IIF
 (
 EXISTS
 (
 SELECT C.* 
 FROM #tTree AS C 
 WHERE C.parentId = TT.id
 ), 
 1, 0
 ),
 element = 
 (
 SELECT
 TT.id,
 TT.[text], 
 TT.[path], 
 TT.depth,
 TT.expanded
 FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
 )
 FROM Recursion AS R
 JOIN #tTree AS TT
 WITH (FORCESEEK)
 ON TT.parentID = R.id
 ),
 AddNextDepth AS
 (
 SELECT
 R.*,
 NextDepth = 
 LEAD(R.depth) OVER (
 ORDER BY R.rpath)
 FROM Recursion AS R
 ),
 ModifiedTree AS
 (
 SELECT 
 ND.rpath,
 element =
 CONCAT
 (
 IIF
 (
 ND.has_children = 0,
 ND.element,
 -- Insert "children" element
 STUFF
 (
 ND.element,
 LEN(ND.element),
 1,
 N',"children":['
 )
 ),
 -- Close previously opened array(s) if necessary
 REPLICATE
 (
 N']}', 
 -- Number of closures needed
 ND.depth - ISNULL(ND.NextDepth, 1)
 ),
 -- Add comma if no children and not the last line
 IIF
 (
 ND.has_children = 0 AND ND.NextDepth IS NOT NULL, 
 N',', 
 N''
 )
 )
 FROM AddNextDepth AS ND
 )
-- Concatenate objects in path order and add array wrapper
SELECT
 CONCAT
 (
 N'[',
 STRING_AGG(MT.element, N'') 
 WITHIN GROUP (ORDER BY MT.rpath),
 N']'
 )
FROM ModifiedTree AS MT
OPTION (MAXRECURSION 0)" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0288089" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF7FCFF94E54EB0A1" QueryPlanHash="0x0BF6F9186C0D0FC5" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" 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="112" CompileTime="88" CompileCPU="83" CompileMemory="1120"><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(nvarchar(4000),[TT].[id],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(12),[TT].[id],0)"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="672" RequiredMemory="512" DesiredMemory="672" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="426544" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="321228" EstimatedPagesCached="20076" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1463632"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-12-04T08:27:00.75" ModificationCount="0" SamplingPercent="100" Statistics="[PK__#tTree____3213E83E1FCB197E]" Table="[#tTree______________________________________________________________________________________________________________00000000001E]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-12-04T08:27:00.72" ModificationCount="0" SamplingPercent="100" Statistics="[UQ__#tTree____7344B21BB600B6AA]" Table="[#tTree______________________________________________________________________________________________________________00000000001E]" 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><QueryTimeStats ElapsedTime="18" CpuTime="18"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0288089" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1029"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1029"></ColumnReference><ScalarOperator ScalarString="concat(CONVERT_IMPLICIT(nvarchar(max),N'[',0),[Expr1028],CONVERT_IMPLICIT(nvarchar(max),N']',0))"><Intrinsic FunctionName="concat"><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="N'['"></Const></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="N']'"></Const></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="5.45e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0288088" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1028"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="14" ActualCPUms="14" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="STRING_AGG(concat(CASE WHEN [Recr1024]=(0) THEN [Recr1025] ELSE stuff([Recr1025],len([Recr1025]),(1),N',"children":[') END,CONVERT_IMPLICIT(nvarchar(max),replicate(N']}',[Recr1022]-isnull([Expr1026],(1))),0),CONVERT_IMPLICIT(nvarchar(max),CASE WHEN [Recr1024]=(0) AND [Expr1026] IS NOT NULL THEN N',' ELSE N'' END,0)),N'')WITHIN GROUP (ORDER BY [Recr1023])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Recr1024"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Recr1025"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Intrinsic FunctionName="stuff"><ScalarOperator><Identifier><ColumnReference Column="Recr1025"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="len"><ScalarOperator><Identifier><ColumnReference Column="Recr1025"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="N',"children":['"></Const></ScalarOperator></Intrinsic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="replicate"><ScalarOperator><Const ConstValue="N']}'"></Const></ScalarOperator><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Recr1022"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="isnull"><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Arithmetic></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Recr1024"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="N','"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="N''"></Const></ScalarOperator></Else></IF></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="N''"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="8.25" EstimateIO="0" EstimateCPU="5.181e-06" AvgRowSize="8077" EstimatedTotalSubtreeCost="0.0288034" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="13" ActualCPUms="13" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="LAST_VALUE([Recr1022])"><Aggregate Distinct="0" AggType="LAST_VALUE"><ScalarOperator><Identifier><ColumnReference Column="Recr1022"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1022"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1022])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1022"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1023"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1023])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1023"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1024"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1024])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1024"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1025"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1025])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1025"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1045"></ColumnReference></GroupBy><RelOp NodeId="3" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="16.5" EstimateIO="0" EstimateCPU="1.81335e-05" AvgRowSize="8077" EstimatedTotalSubtreeCost="0.0287982" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="RowNumber1033"></ColumnReference><ColumnReference Column="WindowCount1045"></ColumnReference><ColumnReference Column="Segment1044"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="19" Batches="0" ActualExecutionMode="Row" ActualElapsedms="13" ActualCPUms="13" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="4" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="8.25" EstimateIO="0" EstimateCPU="5.181e-07" AvgRowSize="8077" EstimatedTotalSubtreeCost="0.028778" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="RowNumber1033"></ColumnReference><ColumnReference Column="TopRowNumber1034"></ColumnReference><ColumnReference Column="BottomRowNumber1035"></ColumnReference><ColumnReference Column="Segment1044"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="11" ActualCPUms="11" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1044"></ColumnReference></SegmentColumn><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="8.25" EstimateIO="0" EstimateCPU="8.25e-07" AvgRowSize="8069" EstimatedTotalSubtreeCost="0.0287774" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="RowNumber1033"></ColumnReference><ColumnReference Column="TopRowNumber1034"></ColumnReference><ColumnReference Column="BottomRowNumber1035"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="TopRowNumber1034"></ColumnReference><ScalarOperator ScalarString="[RowNumber1033]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="BottomRowNumber1035"></ColumnReference><ScalarOperator ScalarString="[RowNumber1033]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="8.25" EstimateIO="0" EstimateCPU="6.6e-07" AvgRowSize="8053" EstimatedTotalSubtreeCost="0.0287766" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="RowNumber1033"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="11" ActualCPUms="11" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1033"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="8.25" EstimateIO="0" EstimateCPU="1.65e-07" AvgRowSize="8053" EstimatedTotalSubtreeCost="0.028776" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="Segment1043"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="11" ActualCPUms="11" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1043"></ColumnReference></SegmentColumn><RelOp NodeId="8" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="8.25" EstimateIO="0.0112613" EstimateCPU="0.000147226" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0287758" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="11" ActualCPUms="11" 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 Column="Recr1023"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="9" PhysicalOp="Index Spool" LogicalOp="Lazy Spool" EstimateRows="8.25" EstimateIO="0" EstimateCPU="2.375e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0173673" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Recr1021"></ColumnReference><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="10" ActualCPUms="9" ActualScans="1" ActualLogicalReads="21" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool Stack="1"><RelOp NodeId="10" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="8.25" EstimateIO="0" EstimateCPU="4.75e-09" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0169132" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Recr1021"></ColumnReference><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="1" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Expr1039"></ColumnReference><ColumnReference Column="Expr1041"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1021"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1022"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1023"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1024"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.75e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="4.75e-08" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1039"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1039"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="8049" EstimatedTotalSubtreeCost="0.00691644" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1001"></ColumnReference><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1030] THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-05" AvgRowSize="8042" EstimatedTotalSubtreeCost="0.00691614" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OuterReferences><RelOp NodeId="14" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-05" AvgRowSize="4278" EstimatedTotalSubtreeCost="0.00689744" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><DefinedValues><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference></DefinedValue></DefinedValues><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></OuterReferences><ProbeColumn><ColumnReference Column="Expr1030"></ColumnReference></ProbeColumn><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="4277" EstimatedTotalSubtreeCost="0.0032856" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CONVERT(nvarchar(4000),#tTree.[id] as [TT].[id],0)"><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="275" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[UQ__#tTree____7344B21BB600B6AA]" Alias="[TT]" TableReferenceId="1" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="parentId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="17" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateRowsWithoutRowGoal="1.75" EstimatedRowsRead="1.75" EstimateIO="0.003125" EstimateCPU="0.000158925" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0035993" TableCardinality="10" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[UQ__#tTree____7344B21BB600B6AA]" Alias="[C]" TableReferenceId="1" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[C]" Column="parentId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="#tTree.[id] as [TT].[id]"><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="18" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="6.157e-06" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="FOR JSON"><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></UsedUDXColumns><RelOp NodeId="19" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="3.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></Extension></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="20" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="2.75" EstimateIO="0" EstimateCPU="3.99e-07" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.00999676" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference><ColumnReference Column="Recr1012"></ColumnReference></OuterReferences><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.75e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="4.75e-08" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference><ColumnReference Column="Recr1012"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1041"></ColumnReference><ScalarOperator ScalarString="[Expr1040]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1040"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="22" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="4.75e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="4.75e-08" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1040"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference><ColumnReference Column="Recr1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" 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"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="9" Stack="1"></Spool></RelOp></ComputeScalar></RelOp><RelOp NodeId="23" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="8049" EstimatedTotalSubtreeCost="0.00999632" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="[Recr1009]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Recr1009"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="concat_ws(N'.',[Recr1010],[Expr1032])"><Intrinsic FunctionName="concat_ws"><ScalarOperator><Const ConstValue="N'.'"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1032"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1031] THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1031"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="[Expr1018]"><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="24" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.75" EstimateIO="0" EstimateCPU="7.315e-06" AvgRowSize="4054" EstimatedTotalSubtreeCost="0.00999487" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="10" ActualExecutions="10"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OuterReferences><RelOp NodeId="25" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1.75" EstimateIO="0" EstimateCPU="7.315e-06" AvgRowSize="290" EstimatedTotalSubtreeCost="0.00990549" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="10" ActualExecutions="10"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><DefinedValues><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference></DefinedValue></DefinedValues><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></OuterReferences><ProbeColumn><ColumnReference Column="Expr1031"></ColumnReference></ProbeColumn><RelOp NodeId="26" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="289" EstimatedTotalSubtreeCost="0.00443758" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1032"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1032"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(12),#tTree.[id] as [TT].[id],0)"><Convert DataType="nvarchar" Length="24" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1.75" EstimatedRowsRead="1.75" EstimateIO="0.003125" EstimateCPU="0.000158925" AvgRowSize="275" EstimatedTotalSubtreeCost="0.00443613" TableCardinality="10" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="10" ActualLogicalReads="20" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="7" ActualEndOfScans="10" ActualExecutions="10"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[UQ__#tTree____7344B21BB600B6AA]" Alias="[TT]" TableReferenceId="2" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="parentId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Recr1008]"><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="28" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateRowsWithoutRowGoal="1.75" EstimatedRowsRead="1.75" EstimateIO="0.003125" EstimateCPU="0.000158925" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00540757" TableCardinality="10" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="7" ActualLogicalReads="14" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="5" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[UQ__#tTree____7344B21BB600B6AA]" Alias="[C]" TableReferenceId="2" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[C]" Column="parentId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="#tTree.[id] as [TT].[id]"><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="29" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="2.9032e-05" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1018"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="FOR JSON"><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></UsedUDXColumns><RelOp NodeId="30" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="3.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="7" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></Extension></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp></Concat></RelOp></Spool></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |