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.3.1" Build="12.0.5000.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementEstRows="14.0752" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.353911" StatementText="select * from(select *,ROW_NUMBER() OVER (PARTITION BY itemid ORDER BY origdate desc)as RowNum
FROM Items)t1

 where OrigDate < getdate() and OrigHand=930" StatementType="SELECT" QueryHash="0x6F49AEB9EC2AA699" QueryPlanHash="0xD170B08F2C150C2F" RetrievedFromCache="true">
- <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="32" CompileTime="1" CompileCPU="1" CompileMemory="272">
- <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="64000" EstimatedPagesCached="32000" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="2265520" />
- <RelOp AvgRowSize="482" EstimateCPU="0.034269" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14.0752" LogicalOp="Filter" NodeId="0" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.353911">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- <ColumnReference Column="Expr1002" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="20" ActualCPUms="20" />
- </RunTimeInformation>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="482" EstimateCPU="0.00311536" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="38942" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="0.319642">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- <ColumnReference Column="Expr1002" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="38942" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="17" ActualCPUms="17" />
- </RunTimeInformation>
- <SequenceProject>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1002" />
- <ScalarOperator ScalarString="row_number">
- <Sequence FunctionName="row_number" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="482" EstimateCPU="0.00077884" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="38942" LogicalOp="Segment" NodeId="2" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="0.316527">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- <ColumnReference Column="Segment1004" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="38942" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="9" ActualCPUms="9" />
- </RunTimeInformation>
- <Segment>
- <GroupBy>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </GroupBy>
- <SegmentColumn>
- <ColumnReference Column="Segment1004" />
- </SegmentColumn>
- <RelOp AvgRowSize="474" EstimateCPU="0.0429932" EstimateIO="0.272755" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="38942" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.315748" TableCardinality="38942">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="38942" ActualRowsRead="38942" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="4" ActualCPUms="4" ActualScans="1" ActualLogicalReads="367" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Index="[PK_Items]" IndexKind="Clustered" Storage="RowStore" />
- </IndexScan>
- </RelOp>
- </Segment>
- </RelOp>
- </SequenceProject>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[MyDatabase].[dbo].[Items].[OrigDate]<getdate() AND [MyDatabase].[dbo].[Items].[OrigHand]=(930)">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1003">
- <ScalarOperator>
- <Intrinsic FunctionName="getdate" />
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(930)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="2" StatementEstRows="14.0752" StatementId="2" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.0457806" StatementText="select *,ROW_NUMBER() OVER (PARTITION BY itemid ORDER BY origdate desc)as RowNum
FROM Items

 where OrigDate < getdate() and OrigHand=930" StatementType="SELECT" QueryHash="0xEF837A21385827F9" QueryPlanHash="0x94D0B3BCDAA162F9" RetrievedFromCache="true">
- <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="48" CompileTime="1" CompileCPU="1" CompileMemory="352">
- <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="64000" EstimatedPagesCached="32000" EstimatedAvailableDegreeOfParallelism="4" MaxCompileMemory="2265520" />
- <RelOp AvgRowSize="482" EstimateCPU="1.12601E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14.0752" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="0.0457806">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- <ColumnReference Column="Expr1002" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <SequenceProject>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1002" />
- <ScalarOperator ScalarString="row_number">
- <Sequence FunctionName="row_number" />
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="482" EstimateCPU="2.81504E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14.0752" LogicalOp="Segment" NodeId="1" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="0.0457741">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- <ColumnReference Column="Segment1004" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <Segment>
- <GroupBy>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </GroupBy>
- <SegmentColumn>
- <ColumnReference Column="Segment1004" />
- </SegmentColumn>
- <RelOp AvgRowSize="474" EstimateCPU="5.88343E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14.0752" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0457724">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="0" ActualCPUms="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </OuterReferences>
- <RelOp AvgRowSize="15" EstimateCPU="0.000172483" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14.0752" LogicalOp="Index Seek" NodeId="3" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00329748" TableCardinality="38942">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14" ActualRowsRead="14" ActualEndOfScans="1" ActualExecutions="1" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Index="[IX_Items_5]" IndexKind="NonClustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigHand" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="(930)">
- <Const ConstValue="(930)" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="466" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="13.0752" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="14.0752" LogicalOp="Clustered Index Seek" NodeId="5" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0424161" TableCardinality="38942">
- <OutputList>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="14" ActualRowsRead="14" ActualEndOfScans="0" ActualExecutions="14" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="28" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" />
- </RunTimeInformation>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedOn" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="AddedBy" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ProductID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="SerialCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Comment" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="Active" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LicenseCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="RedCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="InternalCode" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigStorageID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="PurchaseItemID" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="LetLacking" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="TrackStorage" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ForRemove" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="BrandSuit" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OldCodes" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ReleaseGroup" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Index="[PK_Items]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[MyDatabase].[dbo].[Items].[ItemID]">
- <Identifier>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="ItemID" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="[MyDatabase].[dbo].[Items].[OrigDate]<getdate()">
- <Compare CompareOp="LT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[MyDatabase]" Schema="[dbo]" Table="[Items]" Column="OrigDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1003">
- <ScalarOperator>
- <Intrinsic FunctionName="getdate" />
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Segment>
- </RelOp>
- </SequenceProject>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement