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.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="8" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0377987" StatementText="SELECT A.INVENTTRANSIDFATHER,B.INVENTTRANSID,B.TRANSREFID,C.MODELGROUPID,C.COSTGROUPID,C.DIMENSION,C.DIMENSION2_,C.DIMENSION3_ FROM INVENTTRANS A,INVENTTRANS B,INVENTTABLE C WHERE ((A.DATAAREAID=@P1) AND (A.TRANSTYPE=@P2)) AND ((B.DATAAREAID=@P3) AND (((B.INVENTTRANSID=A.INVENTTRANSIDFATHER) AND (B.TRANSREFID=A.TRANSREFID)) AND (B.TRANSTYPE=@P4))) AND ((C.DATAAREAID=@P5) AND (C.ITEMID=B.ITEMID)) 
AND EXISTS (SELECT 'x' FROM INVENTSETTLEMENT D WHERE ((D.DATAAREAID=@P6) AND ((((D.TRANSDATE=@P7) AND (D.VOUCHER=@P8)) AND (D.TRANSRECID=A.RECID)) AND (D.COSTAMOUNTADJUSTMENT<>@P9))))
 GROUP BY A.INVENTTRANSIDFATHER,B.INVENTTRANSID,B.TRANSREFID,C.MODELGROUPID,C.COSTGROUPID,C.DIMENSION,C.DIMENSION2_,C.DIMENSION3_ ORDER BY B.INVENTTRANSID,B.TRANSREFID,C.MODELGROUPID,C.COSTGROUPID,C.DIMENSION,C.DIMENSION2_,C.DIMENSION3_" StatementType="DECLARE CURSOR" QueryHash="0x23ABE85BEC9BA532" QueryPlanHash="0x6A730F5174FA3714">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" MemoryGrant="2176" CachedPlanSize="120" CompileTime="207" CompileCPU="196" CompileMemory="4016">
- <RelOp AvgRowSize="136" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Insert" EstimatedTotalSubtreeCost="0.0377987">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- <ColumnReference Column="Expr1011" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Update DMLRequestSort="false">
- <Object Database="[tempdb]" Index="[CWT_PrimaryKey]" />
- <SetPredicate>
- <ScalarOperator ScalarString="[CWT].[COLUMN0] = [ecc_wrk].[dbo].[INVENTTRANS].[INVENTTRANSIDFATHER] as [A].[INVENTTRANSIDFATHER],[CWT].[COLUMN1] = [ecc_wrk].[dbo].[INVENTTRANS].[INVENTTRANSID] as [B].[INVENTTRANSID],[CWT].[COLUMN2] = [ecc_wrk].[dbo].[INVENTTRANS].[TRANSREFID] as [B].[TRANSREFID],[CWT].[COLUMN3] = [ecc_wrk].[dbo].[INVENTTABLE].[MODELGROUPID] as [C].[MODELGROUPID],[CWT].[COLUMN4] = [ecc_wrk].[dbo].[INVENTTABLE].[COSTGROUPID] as [C].[COSTGROUPID],[CWT].[COLUMN5] = [ecc_wrk].[dbo].[INVENTTABLE].[DIMENSION] as [C].[DIMENSION],[CWT].[COLUMN6] = [ecc_wrk].[dbo].[INVENTTABLE].[DIMENSION2_] as [C].[DIMENSION2_],[CWT].[COLUMN7] = [ecc_wrk].[dbo].[INVENTTABLE].[DIMENSION3_] as [C].[DIMENSION3_],[CWT].[ROWID] = [Expr1011]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN0" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN1" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN2" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN3" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN4" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN5" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN6" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="COLUMN7" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[CWT]" Column="ROWID" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1011" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- <RelOp AvgRowSize="136" EstimateCPU="8E-08" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="0.0277977">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- <ColumnReference Column="Expr1011" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <SequenceProject>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1011" />
- <ScalarOperator ScalarString="i4_row_number">
- <Sequence FunctionName="i4_row_number" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="136" EstimateCPU="2E-08" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Segment" NodeId="2" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="0.0277976">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- <ColumnReference Column="Segment1012" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Segment>
- <GroupBy />
- <SegmentColumn>
- <ColumnReference Column="Segment1012" />
- </SegmentColumn>
- <RelOp AvgRowSize="131" EstimateCPU="0.000100131" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distinct Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0277976">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- </OutputList>
- <MemoryFractions Input="0.25" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="152" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="4" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0164362">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="ITEMID" />
- </OuterReferences>
- <RelOp AvgRowSize="107" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0131489">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="ITEMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </OuterReferences>
- <RelOp AvgRowSize="51" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00986073">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </OuterReferences>
- <RelOp AvgRowSize="59" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657038">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </OuterReferences>
- <RelOp AvgRowSize="63" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="11" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="176154000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTDIMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="DATAAREAID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Index="[I_177ECC_TRANSTYPEITEMIDD50007]" Alias="[A]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSTYPE" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@P1]">
- <Identifier>
- <ColumnReference Column="@P1" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[@P2]">
- <Identifier>
- <ColumnReference Column="@P2" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="53" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="176154000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSREFID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Index="[I_177TRANSIDIDX]" Alias="[A]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTDIMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[DATAAREAID] as [A].[DATAAREAID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="DATAAREAID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[INVENTTRANSID] as [A].[INVENTTRANSID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[INVENTDIMID] as [A].[INVENTDIMID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTDIMID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[RECID] as [A].[RECID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="53" EstimateCPU="0.000159012" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00328401" TableCardinality="314865000">
- <OutputList />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues />
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTSETTLEMENT]" Index="[I_173RECIDTYPEIDX]" Alias="[D]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTSETTLEMENT]" Alias="[D]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTSETTLEMENT]" Alias="[D]" Column="TRANSRECID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@P6]">
- <Identifier>
- <ColumnReference Column="@P6" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[RECID] as [A].[RECID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="RECID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTSETTLEMENT].[TRANSDATE] as [D].[TRANSDATE]=[@P7] AND [ecc_wrk].[dbo].[INVENTSETTLEMENT].[COSTAMOUNTADJUSTMENT] as [D].[COSTAMOUNTADJUSTMENT]<>[@P9] AND [ecc_wrk].[dbo].[INVENTSETTLEMENT].[VOUCHER] as [D].[VOUCHER]=[@P8]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTSETTLEMENT]" Alias="[D]" Column="TRANSDATE" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P7" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTSETTLEMENT]" Alias="[D]" Column="COSTAMOUNTADJUSTMENT" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P9" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTSETTLEMENT]" Alias="[D]" Column="VOUCHER" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P8" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="77" EstimateCPU="0.000158113" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="20" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00328311" TableCardinality="176154000">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="ITEMID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="ITEMID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Index="[I_177TRANSIDIDX]" Alias="[B]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="INVENTTRANSID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@P3]">
- <Identifier>
- <ColumnReference Column="@P3" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[INVENTTRANSIDFATHER] as [A].[INVENTTRANSIDFATHER]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="INVENTTRANSIDFATHER" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[TRANSTYPE] as [B].[TRANSTYPE]=[@P4] AND [ecc_wrk].[dbo].[INVENTTRANS].[TRANSREFID] as [B].[TRANSREFID]=[ecc_wrk].[dbo].[INVENTTRANS].[TRANSREFID] as [A].[TRANSREFID]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSTYPE" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@P4" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="TRANSREFID" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[A]" Column="TRANSREFID" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="69" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="21" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="272925">
- <OutputList>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="COSTGROUPID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION2_" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DIMENSION3_" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="MODELGROUPID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Index="[I_175ITEMIDX]" Alias="[C]" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="DATAAREAID" />
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTABLE]" Alias="[C]" Column="ITEMID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[@P5]">
- <Identifier>
- <ColumnReference Column="@P5" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="[ecc_wrk].[dbo].[INVENTTRANS].[ITEMID] as [B].[ITEMID]">
- <Identifier>
- <ColumnReference Database="[ecc_wrk]" Schema="[dbo]" Table="[INVENTTRANS]" Alias="[B]" Column="ITEMID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Sort>
- </RelOp>
- </Segment>
- </RelOp>
- </SequenceProject>
- </RelOp>
- </Update>
- </RelOp>
- <ParameterList>
- <ColumnReference Column="@P9" ParameterCompiledValue="(0.000000000000)" ParameterRuntimeValue="(0.000000000000)" />
- <ColumnReference Column="@P8" ParameterCompiledValue="N'IM17008141934'" ParameterRuntimeValue="N'IM17008141934'" />
- <ColumnReference Column="@P7" ParameterCompiledValue="'2017-05-17 00:00:00.000'" ParameterRuntimeValue="'2017-05-17 00:00:00.000'" />
- <ColumnReference Column="@P6" ParameterCompiledValue="N'dat'" ParameterRuntimeValue="N'dat'" />
- <ColumnReference Column="@P5" ParameterCompiledValue="N'dat'" ParameterRuntimeValue="N'dat'" />
- <ColumnReference Column="@P4" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" />
- <ColumnReference Column="@P3" ParameterCompiledValue="N'dat'" ParameterRuntimeValue="N'dat'" />
- <ColumnReference Column="@P2" ParameterCompiledValue="(8)" ParameterRuntimeValue="(8)" />
- <ColumnReference Column="@P1" ParameterCompiledValue="N'dat'" ParameterRuntimeValue="N'dat'" />
- </ParameterList>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="9" StatementEstRows="1" StatementId="2" StatementOptmLevel="TRIVIAL" StatementSubTreeCost="0.0032831" StatementText="FETCH API_CURSOR000000000018F935" StatementType="FETCH CURSOR" QueryHash="0xDE0A8956E6777167" QueryPlanHash="0x6CA9D6155BA9E0CE">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan DegreeOfParallelism="0" CachedPlanSize="120" CompileTime="0" CompileCPU="0" CompileMemory="424">
- <RelOp AvgRowSize="140" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="0" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="0">
- <OutputList>
- <ColumnReference Table="[CWT]" Column="COLUMN0" />
- <ColumnReference Table="[CWT]" Column="COLUMN1" />
- <ColumnReference Table="[CWT]" Column="COLUMN2" />
- <ColumnReference Table="[CWT]" Column="COLUMN3" />
- <ColumnReference Table="[CWT]" Column="COLUMN4" />
- <ColumnReference Table="[CWT]" Column="COLUMN5" />
- <ColumnReference Table="[CWT]" Column="COLUMN6" />
- <ColumnReference Table="[CWT]" Column="COLUMN7" />
- <ColumnReference Table="[CWT]" Column="ROWID" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN0" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN1" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN2" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN3" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN4" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN5" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN6" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="COLUMN7" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Table="[CWT]" Column="ROWID" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[tempdb]" Index="[CWT_PrimaryKey]" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Table="[CWT]" Column="ROWID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="FETCH_RANGE((0))">
- <Identifier>
- <ColumnReference Column="ConstExpr1002">
- <ScalarOperator>
- <Intrinsic FunctionName="FETCH_RANGE">
- <ScalarOperator>
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LT">
- <RangeColumns>
- <ColumnReference Table="[CWT]" Column="ROWID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="FETCH_RANGE((1))">
- <Identifier>
- <ColumnReference Column="ConstExpr1003">
- <ScalarOperator>
- <Intrinsic FunctionName="FETCH_RANGE">
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement