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.1" Build="10.50.4000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="11" StatementEstRows="1" StatementId="1" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.0369164" StatementText="DELETE FROM [dbo].[Table1] 
WHERE
 ([ID] = @p0) 
 AND ([Table3ID] = @p1) 
 AND ([Table4ID] = @p2) 
 AND ([Table5ID] = @p3) 
 AND ([X] = @p4) 
 AND (NOT ([Z] = 1)) 
 AND (NOT ([Q] = 1)) 
 AND ([Y] = @p5) 
 AND ([Table4Raw] = @p6) 
 AND ([Table5Raw] = @p7) 
 AND ([Created] = @p8) 
 AND ([Modified] = @p9)

" StatementType="DELETE" QueryHash="0xCF4217B747947097" QueryPlanHash="0x9D894B969646B422">
- <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="1" CachedPlanSize="40" CompileTime="4" CompileCPU="4" CompileMemory="512">
- <RelOp AvgRowSize="9" EstimateCPU="1.8E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Assert" NodeId="1" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.0369164">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Assert StartupExpression="false">
- <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0369162">
- <OutputList>
- <ColumnReference Column="Expr1009" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1009" />
- </DefinedValue>
- </DefinedValues>
- <OuterReferences>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="ID" />
- </OuterReferences>
- <ProbeColumn>
- <ColumnReference Column="Expr1009" />
- </ProbeColumn>
- <RelOp AvgRowSize="11" EstimateCPU="3E-06" EstimateIO="0.03" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Delete" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Delete" EstimatedTotalSubtreeCost="0.0332863">
- <OutputList>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="ID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Update DMLRequestSort="false">
- <Object Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Index="[PK_Table1]" IndexKind="Clustered" />
- <Object Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Index="[UX_Table1_1]" IndexKind="NonClustered" />
- <Object Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Index="[IX_Table1_01]" IndexKind="NonClustered" />
- <RelOp AvgRowSize="83" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="3536120">
- <OutputList>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="ID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="ID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Index="[PK_Table1]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="ID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@p0]">
- <Identifier>
- <ColumnReference Column="@p0" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[MyDB].[dbo].[Table1].[Table3ID]=[@p1] AND [MyDB].[dbo].[Table1].[Table4ID]=[@p2] AND [MyDB].[dbo].[Table1].[Table5ID]=[@p3] AND [MyDB].[dbo].[Table1].[X]=[@p4] AND [MyDB].[dbo].[Table1].[Y]=[@p5] AND [MyDB].[dbo].[Table1].[Created]=[@p8] AND [MyDB].[dbo].[Table1].[Modified]=[@p9] AND [MyDB].[dbo].[Table1].[Table4Raw]=[@p6] AND [MyDB].[dbo].[Table1].[Table5Raw]=[@p7] AND ([MyDB].[dbo].[Table1].[Z]<(1) OR [MyDB].[dbo].[Table1].[Z]>(1)) AND ([MyDB].[dbo].[Table1].[Q]<(1) OR [MyDB].[dbo].[Table1].[Q]>(1))">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Table3ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p1" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Table4ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p2" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Table5ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p3" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="X" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p4" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Y" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p5" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Created" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p8" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Modified" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p9" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Table4Raw" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p6" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Table5Raw" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@p7" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Z" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Z" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Q" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="Q" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Update>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="1.22907" EstimateIO="10.7142" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Scan" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00361988" TableCardinality="1117190">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="true" ForceScan="false" NoExpandHint="false">
- <DefinedValues />
- <Object Database="[MyDB]" Schema="[dbo]" Table="[Table2]" Index="[PK_Table2]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[MyDB].[dbo].[Table2].[Table1ID]=[MyDB].[dbo].[Table1].[ID]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table2]" Column="Table1ID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDB]" Schema="[dbo]" Table="[Table1]" Column="ID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="CASE WHEN NOT [Expr1009] IS NULL THEN (0) ELSE NULL END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Logical Operation="NOT">
- <ScalarOperator>
- <Logical Operation="IS NULL">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1009" />
- </Identifier>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </Predicate>
- </Assert>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@p9" ParameterRuntimeValue="'2012-12-12 11:36:44.773'" />
- <ColumnReference Column="@p8" ParameterRuntimeValue="'2012-12-12 11:36:44.773'" />
- <ColumnReference Column="@p7" ParameterRuntimeValue="'Y'" />
- <ColumnReference Column="@p6" ParameterRuntimeValue="'BF^3051'" />
- <ColumnReference Column="@p5" ParameterRuntimeValue="(3)" />
- <ColumnReference Column="@p4" ParameterRuntimeValue="(0)" />
- <ColumnReference Column="@p3" ParameterRuntimeValue="(1)" />
- <ColumnReference Column="@p2" ParameterRuntimeValue="(17550)" />
- <ColumnReference Column="@p1" ParameterRuntimeValue="(403479)" />
- <ColumnReference Column="@p0" ParameterRuntimeValue="(4345383)" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement