Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="11.0.2218.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="3" StatementEstRows="48696.8" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="1856810" StatementText="SELECT CAST (
 REPLACE (
 REPLACE (
 XEventData.XEvent.value ('(data/value)[1]', 'varchar(max)'),
 '<victim-list>', '<deadlock><victim-list>'),
 '<process-list>', '</victim-list><process-list>')
 AS XML) AS DeadlockGraph
FROM (SELECT CAST (target_data AS XML) AS TargetData
 FROM sys.dm_xe_session_targets st
 JOIN sys.dm_xe_sessions s ON s.address = st.event_session_address
 WHERE [name] = 'system_health') AS Data
CROSS APPLY TargetData.nodes ('//RingBufferTarget/event') AS XEventData (XEvent)
 WHERE XEventData.XEvent.value('@name', 'varchar(4000)') = 'xml_deadlock_report';" StatementType="SELECT" QueryHash="0xBCCE3D0A893B2331" QueryPlanHash="0x326574A9EE4C6AC3">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="4" MemoryGrant="168" CachedPlanSize="96" CompileTime="6" CompileCPU="6" CompileMemory="1368">
- <RelOp AvgRowSize="4035" EstimateCPU="0.00486968" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1856810">
- <OutputList>
- <ColumnReference Column="Expr1023" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1023" />
- <ScalarOperator ScalarString="CONVERT(xml,replace(replace([Expr1022],'<victim-list>',CONVERT_IMPLICIT(varchar(max),'<deadlock><victim-list>',0)),'<process-list>',CONVERT_IMPLICIT(varchar(max),'</victim-list><process-list>',0)),0)">
- <Convert DataType="xml" Style="0" Implicit="false">
- <ScalarOperator>
- <Intrinsic FunctionName="replace">
- <ScalarOperator>
- <Intrinsic FunctionName="replace">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1022" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'<victim-list>'" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1025">
- <ScalarOperator>
- <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
- <ScalarOperator>
- <Const ConstValue="'<deadlock><victim-list>'" />
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'<process-list>'" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1024">
- <ScalarOperator>
- <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
- <ScalarOperator>
- <Const ConstValue="'</victim-list><process-list>'" />
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4035" EstimateCPU="6.83459" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1856810">
- <OutputList>
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Parallelism>
- <RelOp AvgRowSize="4035" EstimateCPU="0.101776" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Inner Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1856800">
- <OutputList>
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Column="Expr1000" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OuterReferences>
- <RelOp AvgRowSize="4093" EstimateCPU="0.426787" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="48696.8" LogicalOp="Filter" NodeId="3" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="1796810">
- <OutputList>
- <ColumnReference Column="Expr1000" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="6095" EstimateCPU="3.7166" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1778280" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1796810">
- <OutputList>
- <ColumnReference Column="Expr1000" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="3782" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Column="Expr1000" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OuterReferences>
- <RelOp AvgRowSize="4093" EstimateCPU="3.7166" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1778280" LogicalOp="Inner Join" NodeId="5" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17859.5">
- <OutputList>
- <ColumnReference Column="Expr1000" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="3782" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Column="Expr1000" />
- </OuterReferences>
- <RelOp AvgRowSize="4085" EstimateCPU="0.0660916" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="17782.8" LogicalOp="Inner Join" NodeId="6" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.114713">
- <OutputList>
- <ColumnReference Column="Expr1000" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.0288822" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="177.828" LogicalOp="Distribute Streams" NodeId="7" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0290602">
- <OutputList>
- <ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="RoundRobin">
- <RelOp AvgRowSize="15" EstimateCPU="0.000177985" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="177.828" LogicalOp="Table-valued function" NodeId="8" Parallel="false" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.000177985">
- <OutputList>
- <ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[DM_XE_SESSIONS]" />
- <ParameterList>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="N'system_health'">
- <Const ConstValue="N'system_health'" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </Parallelism>
- </RelOp>
- <RelOp AvgRowSize="4085" EstimateCPU="1E-05" EstimateIO="0" EstimateRebinds="164.493" EstimateRewinds="12.3352" EstimateRows="177.828" LogicalOp="Compute Scalar" NodeId="13" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0195612">
- <OutputList>
- <ColumnReference Column="Expr1000" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1000" />
- <ScalarOperator ScalarString="CONVERT(xml,DM_XE_SESSION_TARGETS.[target_data],0)">
- <Convert DataType="xml" Style="0" Implicit="false">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="target_data" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4085" EstimateCPU="0.000100157" EstimateIO="0" EstimateRebinds="164.493" EstimateRewinds="12.3352" EstimateRows="100" LogicalOp="Table-valued function" NodeId="14" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="0.017783">
- <OutputList>
- <ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="target_data" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[DM_XE_SESSION_TARGETS]" Column="target_data" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[DM_XE_SESSION_TARGETS]" />
- <ParameterList>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="DM_XE_SESSIONS.[address]">
- <Identifier>
- <ColumnReference Table="[DM_XE_SESSIONS]" Column="address" />
- </Identifier>
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="17" EstimateCPU="9.6E-05" EstimateIO="0" EstimateRebinds="17649.4" EstimateRewinds="132.352" EstimateRows="100" LogicalOp="Filter" NodeId="20" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="17855.6">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="2" ActualRewinds="0" ActualRows="3782" ActualEndOfScans="2" ActualExecutions="2" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="true">
- <RelOp AvgRowSize="17" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="17649.4" EstimateRewinds="132.352" EstimateRows="200" LogicalOp="Table-valued function" NodeId="21" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="17853.9">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="2" ActualRewinds="0" ActualRows="3782" ActualEndOfScans="2" ActualExecutions="2" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[XML Reader with XPath filter]" />
- <ParameterList>
- <ScalarOperator ScalarString="[Expr1000]">
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[Expr1000] IS NOT NULL">
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="2011" EstimateCPU="3.37188E-06" EstimateIO="0" EstimateRebinds="1776950" EstimateRewinds="1332.52" EstimateRows="1" LogicalOp="Aggregate" NodeId="27" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="1778950">
- <OutputList>
- <ColumnReference Column="Expr1008" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="3782" ActualEndOfScans="0" ActualExecutions="3782" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1008" />
- <ScalarOperator ScalarString="MIN(CASE WHEN [Expr1000] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])>=(128) THEN CONVERT_IMPLICIT(varchar(4000),XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(varchar(4000),XML Reader with XPath filter.[value],0) END END)">
- <Aggregate AggType="MIN" Distinct="false">
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Intrinsic FunctionName="datalength">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(128)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Convert DataType="varchar" Length="4000" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Convert DataType="varchar" Length="4000" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="4057" EstimateCPU="1.224E-05" EstimateIO="0" EstimateRebinds="1776950" EstimateRewinds="1332.52" EstimateRows="4.78647" LogicalOp="Filter" NodeId="28" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="1778940">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="3782" ActualEndOfScans="3782" ActualExecutions="3782" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="4065" EstimateCPU="1.00036" EstimateIO="0" EstimateRebinds="1776950" EstimateRewinds="1332.52" EstimateRows="18" LogicalOp="Table-valued function" NodeId="29" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="1778920">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="3782" ActualRewinds="0" ActualRows="3782" ActualEndOfScans="3782" ActualExecutions="3782" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[XML Reader with XPath filter]" />
- <ParameterList>
- <ScalarOperator ScalarString="[Expr1000]">
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(7)">
- <Const ConstValue="(7)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="XML Reader with XPath filter.[id]">
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </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" />
- </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" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="getancestor">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[Expr1008]='xml_deadlock_report'">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1008" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'xml_deadlock_report'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- <RelOp AvgRowSize="4035" EstimateCPU="0.0004325" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Aggregate" NodeId="39" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="59990.3">
- <OutputList>
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <StreamAggregate>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1022" />
- <ScalarOperator ScalarString="MIN(CASE WHEN [Expr1000] IS NULL THEN NULL ELSE CASE WHEN datalength([Expr1019])>=(128) THEN CONVERT_IMPLICIT(varchar(max),[Expr1020],0) ELSE CONVERT_IMPLICIT(varchar(max),[Expr1019],0) END END)">
- <Aggregate AggType="MIN" Distinct="false">
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Intrinsic FunctionName="datalength">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1019" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(128)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1020" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1019" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Aggregate>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="8045" EstimateCPU="0.00072" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="720" LogicalOp="UDX" NodeId="40" Parallel="true" PhysicalOp="UDX" EstimatedTotalSubtreeCost="59969.2">
- <OutputList>
- <ColumnReference Column="Expr1019" />
- <ColumnReference Column="Expr1020" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Extension UDXName="XQUERY DATA">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1017" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1018" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1019" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1020" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1021" />
- </DefinedValue>
- </DefinedValues>
- <UsedUDXColumns>
- <ColumnReference Table="[XML Reader]" Column="id" />
- <ColumnReference Table="[XML Reader]" Column="nid" />
- <ColumnReference Table="[XML Reader]" Column="tid" />
- <ColumnReference Table="[XML Reader]" Column="value" />
- <ColumnReference Table="[XML Reader]" Column="lvalue" />
- <ColumnReference Table="[XML Reader]" Column="lvaluebin" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Table="[XML Reader]" Column="id" />
- </UsedUDXColumns>
- <RelOp AvgRowSize="8559" EstimateCPU="0.003762" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="900" LogicalOp="Inner Join" NodeId="41" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="59934.1">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Table="[XML Reader]" Column="id" />
- <ColumnReference Table="[XML Reader]" Column="nid" />
- <ColumnReference Table="[XML Reader]" Column="tid" />
- <ColumnReference Table="[XML Reader]" Column="value" />
- <ColumnReference Table="[XML Reader]" Column="lvalue" />
- <ColumnReference Table="[XML Reader]" Column="lvaluebin" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="124" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1027" />
- </OuterReferences>
- <RelOp AvgRowSize="921" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Top" NodeId="42" Parallel="true" PhysicalOp="Top" EstimatedTotalSubtreeCost="10177.7">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1027" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1)">
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="921" EstimateCPU="4.78647E-07" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="43" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="10177.7">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1013" />
- <ColumnReference Column="Expr1027" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1013" />
- <ScalarOperator ScalarString="0x58">
- <Const ConstValue="0x58" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="469" EstimateCPU="1.224E-05" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="1" LogicalOp="Filter" NodeId="44" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="10177.6">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1027" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="469" EstimateCPU="1.8E-06" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="3.7606" LogicalOp="Compute Scalar" NodeId="45" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="10177.5">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- <ColumnReference Column="Expr1027" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1027" />
- <ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])">
- <Intrinsic FunctionName="getdescendantlimit">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="17" EstimateCPU="1.00036" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="3.7606" LogicalOp="Table-valued function" NodeId="46" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="10177.5">
- <OutputList>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[XML Reader with XPath filter]" />
- <ParameterList>
- <ScalarOperator ScalarString="[Expr1000]">
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(7)">
- <Const ConstValue="(7)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="XML Reader with XPath filter.[id]">
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </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" />
- </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],(2))">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="getancestor">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(2)" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Top>
- </RelOp>
- <RelOp AvgRowSize="8099" EstimateCPU="1.018" EstimateIO="0" EstimateRebinds="48476.1" EstimateRewinds="219.673" EstimateRows="900" LogicalOp="Table-valued function" NodeId="59" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="49573.3">
- <OutputList>
- <ColumnReference Table="[XML Reader]" Column="id" />
- <ColumnReference Table="[XML Reader]" Column="nid" />
- <ColumnReference Table="[XML Reader]" Column="tid" />
- <ColumnReference Table="[XML Reader]" Column="value" />
- <ColumnReference Table="[XML Reader]" Column="lvalue" />
- <ColumnReference Table="[XML Reader]" Column="lvaluebin" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="4" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="124" ActualEndOfScans="1" ActualExecutions="1" />
- <RunTimeCountersPerThread Thread="3" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableValuedFunction>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[XML Reader]" Column="id" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader]" Column="nid" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader]" Column="tid" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader]" Column="value" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader]" Column="lvalue" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[XML Reader]" Column="lvaluebin" />
- </DefinedValue>
- </DefinedValues>
- <Object Table="[XML Reader]" />
- <ParameterList>
- <ScalarOperator ScalarString="[Expr1000]">
- <Identifier>
- <ColumnReference Column="Expr1000" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="(7)">
- <Const ConstValue="(7)" />
- </ScalarOperator>
- <ScalarOperator ScalarString="XML Reader with XPath filter.[id]">
- <Identifier>
- <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[Expr1027]">
- <Identifier>
- <ColumnReference Column="Expr1027" />
- </Identifier>
- </ScalarOperator>
- </ParameterList>
- </TableValuedFunction>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Extension>
- </RelOp>
- </StreamAggregate>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement