By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table CorrespondenceLog (id int primary key identity(1,1), XMLContent xml);
insert into CorrespondenceLog (XMLContent) values
('<xml>
<account>
<correspondence>
<type>1</type>
<contact>foo</contact>
</correspondence>
</account>
</xml>')
,('<xml>
<account>
<correspondence>
<type>2</type>
<contact>bar</contact>
</correspondence>
</account>
</xml>');
2 rows affected
select * from CorrespondenceLog
| id | XMLContent |
|---|---|
| 1 | <xml><account><correspondence><type>1</type><contact>foo</contact></correspondence></account></xml> |
| 2 | <xml><account><correspondence><type>2</type><contact>bar</contact></correspondence></account></xml> |
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
2 rows affected
select * from CorrespondenceLog
| id | XMLContent |
|---|---|
| 1 | <xml><account><correspondence><type>1</type></correspondence></account></xml> |
| 2 | <xml><account><correspondence><type>2</type></correspondence></account></xml> |
SET STATISTICS XML ON
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE [CorrespondenceLog]
SET 
 XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="319.854" StatementEstRows="1.8" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xA7D57FE5C2ABE031" QueryPlanHash="0x315E8645D051EC82" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="112" CompileTime="15" CompileCPU="15" CompileMemory="1704"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="813656"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1.8" EstimateIO="0.01" EstimateCPU="1.8e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="319.854" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Index="[PK__Correspo__3213E83F70EACEF6]" IndexKind="Clustered" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="PartialDiffUpdate([fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent],[Expr1028])"><ScalarExpressionList><ScalarOperator><Intrinsic FunctionName="PartialDiffUpdate"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.8" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="4039" EstimatedTotalSubtreeCost="319.844" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[Expr1028]"><Identifier><ColumnReference Column="Expr1028"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.8" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="4039" EstimatedTotalSubtreeCost="319.844" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="[Expr1027]"><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1.8" EstimateIO="0" EstimateCPU="5.04e-007" AvgRowSize="4039" EstimatedTotalSubtreeCost="319.844" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Assert StartupExpression="0"><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1.8" EstimateIO="0" EstimateCPU="7.524e-006" AvgRowSize="4043" EstimatedTotalSubtreeCost="319.844" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></OuterReferences><RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1.8" EstimateIO="0" EstimateCPU="7.524e-006" AvgRowSize="4043" EstimatedTotalSubtreeCost="3.60467" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></OuterReferences><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.8" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="4043" EstimatedTotalSubtreeCost="0.00328534" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference><ColumnReference Column="Expr1031"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1031"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent] IS NULL THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.8" EstimateIO="0" EstimateCPU="9.6e-007" AvgRowSize="4039" EstimatedTotalSubtreeCost="0.00328516" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimatedRowsRead="2" EstimateIO="0.003125" EstimateCPU="0.0001592" AvgRowSize="4039" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Index="[PK__Correspo__3213E83F70EACEF6]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp><RelOp NodeId="9" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateRowsWithoutRowGoal="200" EstimateIO="0" EstimateCPU="0.000836" AvgRowSize="9" EstimatedTotalSubtreeCost="3.60138" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="10" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="1" EstimateRowsWithoutRowGoal="200" EstimateIO="0" EstimateCPU="1.004" AvgRowSize="461" EstimatedTotalSubtreeCost="0.00903616" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="2" ActualRewinds="0" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent]"><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><RelOp NodeId="11" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="4.00149" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="913" EstimatedTotalSubtreeCost="4.00149" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.224e-005" AvgRowSize="461" EstimatedTotalSubtreeCost="4.00149" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="14" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="18" EstimateIO="0" EstimateCPU="1.00036" AvgRowSize="461" EstimatedTotalSubtreeCost="4.00144" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="2" ActualRewinds="0" ActualEndOfScans="2" ActualExecutions="2"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent]"><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator><ScalarOperator ScalarString="XML Reader with XPath filter.[id]"><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getdescendantlimit"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="getancestor"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></Top></RelOp></NestedLoops></RelOp></NestedLoops></RelOp><RelOp NodeId="15" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="4.8e-007" AvgRowSize="4035" EstimatedTotalSubtreeCost="316.24" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="16" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-006" AvgRowSize="4035" EstimatedTotalSubtreeCost="316.24" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="XML SERIALIZER"><DefinedValues><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="taguri"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tagname"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvalue"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvaluebin"></ColumnReference><ColumnReference Table="[XML Reader]" Column="hid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsinil"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsitype"></ColumnReference><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></UsedUDXColumns><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="21453" EstimatedTotalSubtreeCost="316.24" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="taguri"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tagname"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvalue"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvaluebin"></ColumnReference><ColumnReference Table="[XML Reader]" Column="hid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsinil"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsitype"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="(-1)"><Const ConstValue="(-1)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Merge Join" LogicalOp="Left Anti Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0476001" AvgRowSize="20989" EstimatedTotalSubtreeCost="316.24" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="taguri"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tagname"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvalue"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvaluebin"></ColumnReference><ColumnReference Table="[XML Reader]" Column="hid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsinil"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsitype"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><Merge ManyToMany="0"><InnerSideJoinColumns><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></InnerSideJoinColumns><OuterSideJoinColumns><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OuterSideJoinColumns><Residual><ScalarOperator ScalarString="XML Reader.[id]=XML Reader.[id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Residual><RelOp NodeId="19" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="10000" EstimateIO="0" EstimateCPU="1.2" AvgRowSize="20989" EstimatedTotalSubtreeCost="2.16" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="taguri"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tagname"></ColumnReference><ColumnReference Table="[XML Reader]" Column="tid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvalue"></ColumnReference><ColumnReference Table="[XML Reader]" Column="lvaluebin"></ColumnReference><ColumnReference Table="[XML Reader]" Column="hid"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsinil"></ColumnReference><ColumnReference Table="[XML Reader]" Column="xsitype"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="taguri"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="tagname"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="tid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="lvalue"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="lvaluebin"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="hid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="xsinil"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="xsitype"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent]"><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><RelOp NodeId="21" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1643.17" EstimateIO="0" EstimateCPU="7.67316" AvgRowSize="461" EstimatedTotalSubtreeCost="313.994" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="XML Reader with XPath filter.[id]<=XML Reader.[id] AND [Expr1033]>XML Reader.[id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate><RelOp NodeId="22" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="10000" EstimateIO="0" EstimateCPU="1.2" AvgRowSize="461" EstimatedTotalSubtreeCost="2.16" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0.341641" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent]"><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><RelOp NodeId="23" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="200" EstimateIO="0.01" EstimateCPU="0.0001362" AvgRowSize="913" EstimatedTotalSubtreeCost="295.709" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="17998.5" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="24" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="200" EstimateIO="0" EstimateCPU="0.000836" AvgRowSize="913" EstimatedTotalSubtreeCost="293.246" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="25" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="200" EstimateIO="0" EstimateCPU="1.004" AvgRowSize="461" EstimatedTotalSubtreeCost="1.46419" Parallel="0" EstimateRebinds="0.458359" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent]"><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><RelOp NodeId="26" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="913" EstimatedTotalSubtreeCost="291.781" Parallel="0" EstimateRebinds="290.672" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="27" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="1365" EstimatedTotalSubtreeCost="291.781" Parallel="0" EstimateRebinds="290.672" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="28" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.224e-005" AvgRowSize="913" EstimatedTotalSubtreeCost="291.781" Parallel="0" EstimateRebinds="290.672" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="29" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="18" EstimateIO="0" EstimateCPU="1.8e-006" AvgRowSize="913" EstimatedTotalSubtreeCost="291.777" Parallel="0" EstimateRebinds="290.672" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1033"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getdescendantlimit"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="30" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="18" EstimateIO="0" EstimateCPU="1.00036" AvgRowSize="461" EstimatedTotalSubtreeCost="291.777" Parallel="0" EstimateRebinds="290.672" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent]"><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator><ScalarOperator ScalarString="XML Reader with XPath filter.[id]"><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getdescendantlimit"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ParameterList></TableValuedFunction></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="getancestor"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></Top></RelOp></NestedLoops></RelOp></Spool></RelOp></NestedLoops></RelOp></Merge></RelOp></ComputeScalar></RelOp></Extension></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="[Expr1031]"><Identifier><ColumnReference Column="Expr1031"></ColumnReference></Identifier></ScalarOperator></Predicate></Assert></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
UPDATE
UPDATE
| Cached plan size | 112 KB |
|---|---|
| Estimated Operator Cost | 0 (0%) |
| Estimated Subtree Cost | 319.854 |
| Degree of Parallelism | 0 |
| Estimated Number of Rows | 1.8 |
Statement
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
Clustered Index Update
(Update)
Cost: 0%
Clustered Index Update
| Physical Operation | Clustered Index Update |
|---|---|
| Logical Operation | Update |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.01 (0%) |
| Estimated I/O Cost | 0.01 |
| Estimated CPU Cost | 0.0000018 |
| Estimated Subtree Cost | 319.854 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 0 |
Object
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[PK__Correspo__3213E83F70EACEF6]
Predicate
PartialDiffUpdate([fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent],[Expr1028])
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000002 |
| Estimated Subtree Cost | 319.844 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4039 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 1 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
Expr1028
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Estimated Execution Mode | Row |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000002 |
| Estimated Subtree Cost | 319.844 |
| Estimated Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4039 B |
| Node ID | 2 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
Expr1028
Assert
Cost: 0%
Assert
| Physical Operation | Assert |
|---|---|
| Logical Operation | Assert |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000005 |
| Estimated Subtree Cost | 319.844 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4039 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 3 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
Expr1027
Predicate
[Expr1031]
Nested Loops
(Left Outer Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Left Outer Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000075 |
| Estimated Subtree Cost | 319.844 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4043 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 4 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
Expr1027
Expr1031
Outer References
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].XMLContent
Nested Loops
(Left Semi Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Left Semi Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000047 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000075 |
| Estimated Subtree Cost | 3.60467 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4043 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 5 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].XMLContent
Expr1031
Outer References
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].XMLContent
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Estimated Execution Mode | Row |
| Estimated Operator Cost | 0.0000002 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000002 |
| Estimated Subtree Cost | 0.0032853 |
| Estimated Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4043 B |
| Node ID | 6 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].XMLContent
Expr1031
Filter
Cost: 0%
Filter
| Physical Operation | Filter |
|---|---|
| Logical Operation | Filter |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 2 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.000001 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.000001 |
| Estimated Subtree Cost | 0.0032852 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1.8 |
| Estimated Row Size | 4039 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 7 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].XMLContent
Predicate
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent] IS NOT NULL
Clustered Index Scan (Clustered)
[CorrespondenceLog].[PK__Correspo__…
Cost: 0%
Clustered Index Scan (Clustered)
Scanning a clustered index, entirely or only a range.
| Physical Operation | Clustered Index Scan |
|---|---|
| Logical Operation | Clustered Index Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Storage | RowStore |
| Number of Rows Read | 2 |
| Actual Number of Rows | 2 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0032842 (0%) |
| Estimated I/O Cost | 0.003125 |
| Estimated CPU Cost | 0.0001592 |
| Estimated Subtree Cost | 0.0032842 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows to be Read | 2 |
| Estimated Number of Rows | 2 |
| Estimated Row Size | 4039 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Ordered | True |
| Node ID | 8 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].XMLContent
Object
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[PK__Correspo__3213E83F70EACEF6]
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.000836 |
| Estimated Subtree Cost | 3.60138 |
| Estimated Number of Executions | 1.458359 |
| Number of Executions | 2 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 9 |
Outer References
[XML Reader with XPath filter].id
Table-valued function
[XML Reader with XPath filter]
Cost: 0%
Table-valued function
| Physical Operation | Table-valued function |
|---|---|
| Logical Operation | Table-valued function |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 2 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0090362 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.004 |
| Estimated Subtree Cost | 0.0090362 |
| Estimated Number of Executions | 1.458359 |
| Number of Executions | 2 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 2 |
| Actual Rewinds | 0 |
| Node ID | 10 |
Output List
[XML Reader with XPath filter].id
Object
[XML Reader with XPath filter]
Top
Cost: 0%
Top
Select the first few rows based on a sort order.
| Physical Operation | Top |
|---|---|
| Logical Operation | Top |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000001 |
| Estimated Subtree Cost | 4.00149 |
| Estimated Number of Executions | 4 |
| Number of Executions | 2 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 11 |
Top Expression
(1)
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Estimated Execution Mode | Row |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000001 |
| Estimated Subtree Cost | 4.00149 |
| Estimated Number of Executions | 4 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 913 B |
| Node ID | 12 |
Output List
[XML Reader with XPath filter].id
Expr1009
Filter
Cost: 0%
Filter
| Physical Operation | Filter |
|---|---|
| Logical Operation | Filter |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.00005 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000122 |
| Estimated Subtree Cost | 4.00149 |
| Estimated Number of Executions | 4 |
| Number of Executions | 2 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 13 |
Output List
[XML Reader with XPath filter].id
Predicate
XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))
Table-valued function
[XML Reader with XPath filter]
Cost: 1%
Table-valued function
| Physical Operation | Table-valued function |
|---|---|
| Logical Operation | Table-valued function |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 4.00144 (1%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.00036 |
| Estimated Subtree Cost | 4.00144 |
| Estimated Number of Executions | 4 |
| Number of Executions | 2 |
| Estimated Number of Rows | 18 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 2 |
| Actual Rewinds | 0 |
| Node ID | 14 |
Output List
[XML Reader with XPath filter].id
Object
[XML Reader with XPath filter]
Filter
Cost: 0%
Filter
| Physical Operation | Filter |
|---|---|
| Logical Operation | Filter |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000005 |
| Estimated Subtree Cost | 316.24 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 4035 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 15 |
Output List
Expr1027
Predicate
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent] IS NOT NULL
UDX
Cost: 0%
UDX
| Physical Operation | UDX |
|---|---|
| Logical Operation | UDX |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.000001 |
| Estimated Subtree Cost | 316.24 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 4035 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 16 |
Output List
Expr1027
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Estimated Execution Mode | Row |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000001 |
| Estimated Subtree Cost | 316.24 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 21453 B |
| Node ID | 17 |
Output List
[XML Reader].id
[XML Reader].nid
[XML Reader].taguri
[XML Reader].tagname
[XML Reader].tid
[XML Reader].value
[XML Reader].lvalue
[XML Reader].lvaluebin
[XML Reader].hid
[XML Reader].xsinil
[XML Reader].xsitype
Expr1010
Expr1011
Expr1012
Expr1026
Merge Join
(Left Anti Semi Join)
Cost: 0%
Merge Join
| Physical Operation | Merge Join |
|---|---|
| Logical Operation | Left Anti Semi Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.086 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0476001 |
| Estimated Subtree Cost | 316.24 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 20989 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 18 |
Output List
[XML Reader].id
[XML Reader].nid
[XML Reader].taguri
[XML Reader].tagname
[XML Reader].tid
[XML Reader].value
[XML Reader].lvalue
[XML Reader].lvaluebin
[XML Reader].hid
[XML Reader].xsinil
[XML Reader].xsitype
Table-valued function
[XML Reader]
Cost: 1%
Table-valued function
| Physical Operation | Table-valued function |
|---|---|
| Logical Operation | Table-valued function |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 2.16 (1%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.2 |
| Estimated Subtree Cost | 2.16 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 10000 |
| Estimated Row Size | 20989 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 19 |
Output List
[XML Reader].id
[XML Reader].nid
[XML Reader].taguri
[XML Reader].tagname
[XML Reader].tid
[XML Reader].value
[XML Reader].lvalue
[XML Reader].lvaluebin
[XML Reader].hid
[XML Reader].xsinil
[XML Reader].xsitype
Object
[XML Reader]
Nested Loops
(Left Semi Join)
Cost: 5%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Left Semi Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 16.125 (5%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 7.67316 |
| Estimated Subtree Cost | 313.994 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 1643.17 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 21 |
Output List
[XML Reader].id
Predicate
XML Reader with XPath filter.[id]<=XML Reader.[id] AND [Expr1033]>XML Reader.[id]
Table-valued function
[XML Reader]
Cost: 1%
Table-valued function
| Physical Operation | Table-valued function |
|---|---|
| Logical Operation | Table-valued function |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 2.16 (1%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.2 |
| Estimated Subtree Cost | 2.16 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 10000 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 22 |
Output List
[XML Reader].id
Object
[XML Reader]
Table Spool
(Lazy Spool)
Cost: 1%
Table Spool
| Physical Operation | Table Spool |
|---|---|
| Logical Operation | Lazy Spool |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 2.463 (1%) |
| Estimated I/O Cost | 0.01 |
| Estimated CPU Cost | 0.0001362 |
| Estimated Subtree Cost | 295.709 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 200 |
| Estimated Row Size | 913 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 23 |
Output List
[XML Reader with XPath filter].id
Expr1033
Nested Loops
(Inner Join)
Cost: 0%
Nested Loops
For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.
| Physical Operation | Nested Loops |
|---|---|
| Logical Operation | Inner Join |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.00081 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.000836 |
| Estimated Subtree Cost | 293.246 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 200 |
| Estimated Row Size | 913 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 24 |
Output List
[XML Reader with XPath filter].id
Expr1033
Outer References
[XML Reader with XPath filter].id
Table-valued function
[XML Reader with XPath filter]
Cost: 0%
Table-valued function
| Physical Operation | Table-valued function |
|---|---|
| Logical Operation | Table-valued function |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 1.46419 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.004 |
| Estimated Subtree Cost | 1.46419 |
| Estimated Number of Executions | 1.458359 |
| Estimated Number of Rows | 200 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 25 |
Output List
[XML Reader with XPath filter].id
Object
[XML Reader with XPath filter]
Top
Cost: 0%
Top
Select the first few rows based on a sort order.
| Physical Operation | Top |
|---|---|
| Logical Operation | Top |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000001 |
| Estimated Subtree Cost | 291.781 |
| Estimated Number of Executions | 291.672 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 913 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 26 |
Output List
[XML Reader with XPath filter].id
Expr1033
Top Expression
(1)
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Estimated Execution Mode | Row |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000001 |
| Estimated Subtree Cost | 291.781 |
| Estimated Number of Executions | 291.672 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 1365 B |
| Node ID | 27 |
Output List
[XML Reader with XPath filter].id
Expr1020
Expr1033
Filter
Cost: 0%
Filter
| Physical Operation | Filter |
|---|---|
| Logical Operation | Filter |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.004 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000122 |
| Estimated Subtree Cost | 291.781 |
| Estimated Number of Executions | 291.672 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 913 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 28 |
Output List
[XML Reader with XPath filter].id
Expr1033
Predicate
XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Estimated Execution Mode | Row |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000018 |
| Estimated Subtree Cost | 291.777 |
| Estimated Number of Executions | 291.672 |
| Estimated Number of Rows | 18 |
| Estimated Row Size | 913 B |
| Node ID | 29 |
Output List
[XML Reader with XPath filter].id
Expr1033
Table-valued function
[XML Reader with XPath filter]
Cost: 91%
Table-valued function
| Physical Operation | Table-valued function |
|---|---|
| Logical Operation | Table-valued function |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 291.777 (91%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 1.00036 |
| Estimated Subtree Cost | 291.777 |
| Estimated Number of Executions | 291.672 |
| Estimated Number of Rows | 18 |
| Estimated Row Size | 461 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 30 |
Output List
[XML Reader with XPath filter].id
Object
[XML Reader with XPath filter]
SET STATISTICS XML OFF
CREATE PRIMARY XML INDEX PIdx_CorrespondenceLog_XMLContent
ON CorrespondenceLog(XMLContent);
CREATE XML INDEX PIdx_CorrespondenceLog_XMLContent_PATH
ON CorrespondenceLog(XMLContent)
USING XML INDEX PIdx_CorrespondenceLog_XMLContent FOR PATH;
SET STATISTICS XML ON
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE [CorrespondenceLog]
SET 
 XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1" StatementId="1" StatementCompId="1" StatementType="UPDATE" RetrievedFromCache="true" StatementSubTreeCost="0.0100022" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x3D10F271628C0DB1" QueryPlanHash="0x9A9ED1FE1820323B" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="24" CompileTime="0" CompileCPU="0" CompileMemory="1144"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="813656"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2018-12-21T14:41:48.85" ModificationCount="0" SamplingPercent="100" Statistics="[PIdx_CorrespondenceLog_XMLContent]" Table="[xml_index_nodes_885578193_256000]" Schema="[sys]" Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]"></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="Clustered Index Update" LogicalOp="Update" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0100022" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Index="[PK__Correspo__3213E83F70EACEF6]" IndexKind="Clustered" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="PartialDiffUpdate([fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent],[Expr1027])"><ScalarExpressionList><ScalarOperator><Intrinsic FunctionName="PartialDiffUpdate"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="XMLContent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="4039" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="[Expr1027]"><Identifier><ColumnReference Column="Expr1027"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="4039" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d14f2743a5dd45ff991e92f9519af7ed]" Schema="[dbo]" Table="[CorrespondenceLog]" Column="id"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
UPDATE
UPDATE
| Cached plan size | 24 KB |
|---|---|
| Estimated Operator Cost | 0 (0%) |
| Estimated Subtree Cost | 0.0100022 |
| Degree of Parallelism | 0 |
| Estimated Number of Rows | 1 |
Statement
UPDATE [CorrespondenceLog]
SET
XMLContent.modify('delete //account/correspondence/contact[1]')
WHERE XMLContent.exist('//account/correspondence/contact[1]') = 1
Clustered Index Update
(Update)
Cost: 100%
Clustered Index Update
| Physical Operation | Clustered Index Update |
|---|---|
| Logical Operation | Update |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.010001 (100%) |
| Estimated I/O Cost | 0.01 |
| Estimated CPU Cost | 0.000001 |
| Estimated Subtree Cost | 0.0100022 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 9 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 0 |
Object
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[PK__Correspo__3213E83F70EACEF6]
Predicate
PartialDiffUpdate([fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].[XMLContent],[Expr1027])
Compute Scalar
Cost: 0%
Compute Scalar
Compute new values from existing values in a row.
| Physical Operation | Compute Scalar |
|---|---|
| Logical Operation | Compute Scalar |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000012 |
| Estimated Subtree Cost | 0.0000012 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 4039 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 1 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
Expr1027
Constant Scan
Cost: 0%
Constant Scan
| Physical Operation | Constant Scan |
|---|---|
| Logical Operation | Constant Scan |
| Actual Execution Mode | Row |
| Estimated Execution Mode | Row |
| Actual Number of Rows | 0 |
| Actual Number of Batches | 0 |
| Estimated Operator Cost | 0.0000012 (0%) |
| Estimated I/O Cost | 0 |
| Estimated CPU Cost | 0.0000012 |
| Estimated Subtree Cost | 0.0000012 |
| Estimated Number of Executions | 1 |
| Number of Executions | 1 |
| Estimated Number of Rows | 1 |
| Estimated Row Size | 4039 B |
| Actual Rebinds | 0 |
| Actual Rewinds | 0 |
| Node ID | 2 |
Output List
[fiddle_d14f2743a5dd45ff991e92f9519af7ed].[dbo].[CorrespondenceLog].id
Expr1027