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.5343.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="2" StatementEstRows="1000" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="941.58" StatementText="select top 1000
 a.SourceStore
 ,a.AgreementId
 ,isnull(a.ModifiedDate, a.CreatedDate) as ModifiedDate
 ,ca.CustomerId
from #stores s
inner join StoreOps.Agreement.Agreement a on a.SourceStore = s.Store
inner join StoreOps.Customer.CustomerAgreement ca on ca.SourceStore = a.SourceStore 
 and ca.AgreementId = a.AgreementId 
 and ca.IsPrimary = 1
where ( (a.ModifiedDate between s.StartDate and s.RangeEnd) 
 or ( a.ModifiedDate is null 
 and a.CreatedDate between s.StartDate and s.RangeEnd)
 ) 
 and ( isnull(a.ModifiedDate, a.CreatedDate) > s.StartDate 
 or a.AgreementId > s.LastId
 )
order by isnull(a.ModifiedDate, a.CreatedDate), a.AgreementId" StatementType="SELECT" QueryHash="0x9090161CF657DF63" QueryPlanHash="0x94BED36895E38EB9" 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="2" MemoryGrant="870112" CachedPlanSize="296" CompileTime="28716" CompileCPU="21588" CompileMemory="11008">
- <ThreadStat Branches="2" UsedThreads="4">
- <ThreadReservation NodeId="0" ReservedThreads="4" />
- </ThreadStat>
- <MissingIndexes>
- <MissingIndexGroup Impact="14.4486">
- <MissingIndex Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]">
- <ColumnGroup Usage="EQUALITY">
- <Column Name="[IsPrimary]" ColumnId="4" />
- </ColumnGroup>
- <ColumnGroup Usage="INCLUDE">
- <Column Name="[CustomerId]" ColumnId="2" />
- <Column Name="[AgreementId]" ColumnId="3" />
- <Column Name="[SourceStore]" ColumnId="6" />
- </ColumnGroup>
- </MissingIndex>
- </MissingIndexGroup>
- </MissingIndexes>
- <MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="868216" RequiredMemory="3424" DesiredMemory="870112" RequestedMemory="870112" GrantWaitTime="0" GrantedMemory="870112" MaxUsedMemory="21888" />
- <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="314572" EstimatedPagesCached="78643" EstimatedAvailableDegreeOfParallelism="2" />
- <RelOp AvgRowSize="29" EstimateCPU="0.0001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="941.58">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- <ColumnReference Column="Expr1109" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1000" ActualEndOfScans="1" ActualExecutions="1" />
- </RunTimeInformation>
- <Top RowCount="false" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(1000)">
- <Const ConstValue="(1000)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="29" EstimateCPU="0.0357895" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="941.58">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- <ColumnReference Column="Expr1109" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="0" ActualRows="1000" ActualEndOfScans="0" ActualExecutions="1" />
- </RunTimeInformation>
- <Parallelism>
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Expr1109" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Union1035" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="29" EstimateCPU="295.639" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1000" LogicalOp="TopN Sort" NodeId="2" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="941.544">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- <ColumnReference Column="Expr1109" />
- </OutputList>
- <MemoryFractions Input="0.558887" Output="1" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="1000" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="525" Batches="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TopSort Distinct="false" Rows="1000">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Expr1109" />
- </OrderByColumn>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Union1035" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="29" EstimateCPU="0.286876" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5737520" LogicalOp="Compute Scalar" NodeId="3" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="645.899">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- <ColumnReference Column="Expr1109" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1109" />
- <ScalarOperator ScalarString="isnull([Union1081],[Union1071])">
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1081" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1071" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="37" EstimateCPU="134.497" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="5737520" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="645.612">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1071" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1081" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- </OutputList>
- <MemoryFractions Input="0.999749" Output="0.441113" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="21467" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="21408" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1035" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[StoreOpsV170].[Customer].[CustomerAgreement].[SourceStore]=[Union1075] AND [StoreOpsV170].[Customer].[CustomerAgreement].[AgreementId]=[Union1035]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1075" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Union1035" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="33" EstimateCPU="1.71831" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="599382" LogicalOp="Bitmap Create" NodeId="5" Parallel="true" PhysicalOp="Bitmap" EstimatedTotalSubtreeCost="233.03">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1071" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1081" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="21467" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="21408" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Bitmap>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bitmap1118" />
- </DefinedValue>
- </DefinedValues>
- <HashKeys>
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1035" />
- </HashKeys>
- <RelOp AvgRowSize="33" EstimateCPU="1.71831" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="599382" LogicalOp="Repartition Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="233.03">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1071" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1081" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="21467" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="21408" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1035" />
- </PartitionColumns>
- <RelOp AvgRowSize="33" EstimateCPU="9.42639" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="599382" LogicalOp="Inner Join" NodeId="7" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="231.312">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1071" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1081" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="19714" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="23161" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <NestedLoops Optimized="false">
- <OuterReferences>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </OuterReferences>
- <RelOp AvgRowSize="35" EstimateCPU="0.00060465" EstimateIO="0.00616646" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1028" LogicalOp="Table Scan" NodeId="8" Parallel="true" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00677111" TableCardinality="1028">
- <OutputList>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="426" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="602" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" IndexKind="Heap" />
- </TableScan>
- </RelOp>
- <RelOp AvgRowSize="33" EstimateCPU="0.000438739" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="4387.39" LogicalOp="Concatenation" NodeId="9" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="221.879">
- <OutputList>
- <ColumnReference Column="Union1035" />
- <ColumnReference Column="Union1071" />
- <ColumnReference Column="Union1075" />
- <ColumnReference Column="Union1081" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="19714" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="23161" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Union1035" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1071" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1075" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Union1081" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="35" EstimateCPU="0.00583143" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="580.857" LogicalOp="Distinct Sort" NodeId="10" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="30.7515">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="2022" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="2660" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1003" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="4.21376E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="421.376" LogicalOp="Concatenation" NodeId="11" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="13.1802">
- <OutputList>
- <ColumnReference Column="Bmk1003" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2022" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2660" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1003" />
- <ColumnReference Column="Bmk1003" />
- <ColumnReference Column="Bmk1003" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.00115435" EstimateIO="0.00756944" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="418.647" LogicalOp="Index Seek" NodeId="12" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="8.80886" TableCardinality="3719470">
- <OutputList>
- <ColumnReference Column="Bmk1003" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2021" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2660" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1003" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Index="[IX_POSREPL3Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL3Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL3Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL3Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.000163501" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.72894" LogicalOp="Index Seek" NodeId="13" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.31485" TableCardinality="3719470">
- <OutputList>
- <ColumnReference Column="Bmk1003" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1003" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Index="[IX_POSREPL3Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL3Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL3Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL3Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL3Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.00393581" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="490.627" LogicalOp="Distinct Sort" NodeId="14" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="26.7747">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="1562" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="3612" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1007" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="2.98984E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="298.984" LogicalOp="Concatenation" NodeId="15" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="11.1522">
- <OutputList>
- <ColumnReference Column="Bmk1007" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1562" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3612" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1007" />
- <ColumnReference Column="Bmk1007" />
- <ColumnReference Column="Bmk1007" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.000890336" EstimateIO="0.00608796" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="296.469" LogicalOp="Index Seek" NodeId="16" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.05541" TableCardinality="3993940">
- <OutputList>
- <ColumnReference Column="Bmk1007" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1560" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3608" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1007" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Index="[IX_POSREPL4Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL4Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL4Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL4Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.000163222" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.51534" LogicalOp="Index Seek" NodeId="17" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.31958" TableCardinality="3993940">
- <OutputList>
- <ColumnReference Column="Bmk1007" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="4" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1007" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Index="[IX_POSREPL4Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL4Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL4Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL4Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL4Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.00495907" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="564.814" LogicalOp="Distinct Sort" NodeId="18" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="28.9153">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="2498" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="2726" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1011" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="3.658E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="365.8" LogicalOp="Concatenation" NodeId="19" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="12.2409">
- <OutputList>
- <ColumnReference Column="Bmk1011" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2498" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2726" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1011" />
- <ColumnReference Column="Bmk1011" />
- <ColumnReference Column="Bmk1011" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.00104319" EstimateIO="0.0068287" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="362.653" LogicalOp="Index Seek" NodeId="20" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.97359" TableCardinality="4604910">
- <OutputList>
- <ColumnReference Column="Bmk1011" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2497" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2725" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1011" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Index="[IX_POSREPL5Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL5Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL5Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL5Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.00016469" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.14713" LogicalOp="Index Seek" NodeId="21" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.32748" TableCardinality="4604910">
- <OutputList>
- <ColumnReference Column="Bmk1011" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="1" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1011" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Index="[IX_POSREPL5Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL5Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL5Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL5Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL5Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.00380505" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="514.006" LogicalOp="Distinct Sort" NodeId="22" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="26.6288">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="2176" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="3073" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1015" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="2.90294E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="290.294" LogicalOp="Concatenation" NodeId="23" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="11.1407">
- <OutputList>
- <ColumnReference Column="Bmk1015" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2176" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3073" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1015" />
- <ColumnReference Column="Bmk1015" />
- <ColumnReference Column="Bmk1015" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.000878963" EstimateIO="0.00608796" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="287.685" LogicalOp="Index Seek" NodeId="24" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.0516" TableCardinality="4353400">
- <OutputList>
- <ColumnReference Column="Bmk1015" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2175" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3071" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1015" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Index="[IX_POSREPL6Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL6Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL6Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL6Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.000163549" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="2.60944" LogicalOp="Index Seek" NodeId="25" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.32396" TableCardinality="4353400">
- <OutputList>
- <ColumnReference Column="Bmk1015" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1015" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Index="[IX_POSREPL6Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL6Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL6Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL6Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL6Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.00429912" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="550.514" LogicalOp="Distinct Sort" NodeId="26" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="28.0554">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="2784" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="3381" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1019" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="3.22937E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="322.937" LogicalOp="Concatenation" NodeId="27" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="12.0594">
- <OutputList>
- <ColumnReference Column="Bmk1019" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2784" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3381" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1019" />
- <ColumnReference Column="Bmk1019" />
- <ColumnReference Column="Bmk1019" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.000954053" EstimateIO="0.0068287" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="319.805" LogicalOp="Index Seek" NodeId="28" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.8849" TableCardinality="4708710">
- <OutputList>
- <ColumnReference Column="Bmk1019" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2784" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3381" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1019" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Index="[IX_POSREPL7Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL7Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL7Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL7Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.000164807" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.13226" LogicalOp="Index Seek" NodeId="29" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.32894" TableCardinality="4708710">
- <OutputList>
- <ColumnReference Column="Bmk1019" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1019" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Index="[IX_POSREPL7Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL7Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL7Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL7Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL7Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.0037856" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="550.004" LogicalOp="Distinct Sort" NodeId="30" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="26.635">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="2540" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="3111" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1023" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="2.88998E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="288.998" LogicalOp="Concatenation" NodeId="31" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="11.1669">
- <OutputList>
- <ColumnReference Column="Bmk1023" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2540" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3111" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1023" />
- <ColumnReference Column="Bmk1023" />
- <ColumnReference Column="Bmk1023" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.000883724" EstimateIO="0.00608796" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="285.801" LogicalOp="Index Seek" NodeId="32" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.06533" TableCardinality="4860600">
- <OutputList>
- <ColumnReference Column="Bmk1023" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2538" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="3111" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1023" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Index="[IX_POSREPL8Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL8Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL8Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL8Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.00016513" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.19727" LogicalOp="Index Seek" NodeId="33" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.33012" TableCardinality="4860600">
- <OutputList>
- <ColumnReference Column="Bmk1023" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1023" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Index="[IX_POSREPL8Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL8Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL8Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL8Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL8Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.00372198" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="571.517" LogicalOp="Distinct Sort" NodeId="34" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="26.5672">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="3276" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="2790" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1027" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="2.84753E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="284.753" LogicalOp="Concatenation" NodeId="35" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="11.1645">
- <OutputList>
- <ColumnReference Column="Bmk1027" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="3276" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2790" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1027" />
- <ColumnReference Column="Bmk1027" />
- <ColumnReference Column="Bmk1027" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.000879425" EstimateIO="0.00608796" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="281.572" LogicalOp="Index Seek" NodeId="36" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.06536" TableCardinality="5126310">
- <OutputList>
- <ColumnReference Column="Bmk1027" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="3271" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="2784" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1027" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Index="[IX_POSREPL9Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL9Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL9Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL9Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.000165163" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.18173" LogicalOp="Index Seek" NodeId="37" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.33244" TableCardinality="5126310">
- <OutputList>
- <ColumnReference Column="Bmk1027" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="5" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="6" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1027" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Index="[IX_POSREPL9Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL9Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL9Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL9Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL9Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- <RelOp AvgRowSize="35" EstimateCPU="0.00413294" EstimateIO="0.0112613" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="565.047" LogicalOp="Distinct Sort" NodeId="38" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="27.0999">
- <OutputList>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <MemoryFractions Input="0.000251046" Output="0.000251046" />
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRebinds="426" ActualRewinds="0" ActualRows="2856" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRebinds="602" ActualRewinds="0" ActualRows="1808" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Sort Distinct="true">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Column="Bmk1031" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="43" EstimateCPU="3.12015E-05" EstimateIO="0" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="312.015" LogicalOp="Concatenation" NodeId="39" Parallel="true" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="11.2747">
- <OutputList>
- <ColumnReference Column="Bmk1031" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2856" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="1808" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Concat>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1031" />
- <ColumnReference Column="Bmk1031" />
- <ColumnReference Column="Bmk1031" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="43" EstimateCPU="0.000935107" EstimateIO="0.00608796" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="308.708" LogicalOp="Index Seek" NodeId="40" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="7.11841" TableCardinality="4898530">
- <OutputList>
- <ColumnReference Column="Bmk1031" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="2855" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="1808" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1031" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Index="[IX_POSREPL10Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL10Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL10Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL10Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- <RelOp AvgRowSize="43" EstimateCPU="0.000165336" EstimateIO="0.003125" EstimateRebinds="1027" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="3.30724" LogicalOp="Index Seek" NodeId="41" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.33047" TableCardinality="4898530">
- <OutputList>
- <ColumnReference Column="Bmk1031" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualEndOfScans="426" ActualExecutions="426" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualEndOfScans="602" ActualExecutions="602" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Bmk1031" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Index="[IX_POSREPL10Agreement_SourceStore_ModifiedDate]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="SourceStore" />
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[Store] as [s].[Store]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="Store" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator ScalarString="NULL">
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- <StartRange ScanType="GE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </StartRange>
- <EndRange ScanType="LE">
- <RangeColumns>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[tempdb].[dbo].[#stores].[RangeEnd] as [s].[RangeEnd]">
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="RangeEnd" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </EndRange>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="isnull([POSREPLDB].[POSREPL10Agreement].[Agreement].[ModifiedDate],[POSREPLDB].[POSREPL10Agreement].[Agreement].[CreatedDate])>[tempdb].[dbo].[#stores].[StartDate] as [s].[StartDate] OR [POSREPLDB].[POSREPL10Agreement].[Agreement].[AgreementId]>[tempdb].[dbo].[#stores].[LastId] as [s].[LastId]">
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Intrinsic FunctionName="isnull">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="ModifiedDate" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="CreatedDate" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="StartDate" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="GT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[POSREPLDB]" Schema="[POSREPL10Agreement]" Table="[Agreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#stores]" Alias="[s]" Column="LastId" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Concat>
- </RelOp>
- </Sort>
- </RelOp>
- </Concat>
- </RelOp>
- </NestedLoops>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Bitmap>
- </RelOp>
- <RelOp AvgRowSize="23" EstimateCPU="81.5485" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="36511000" LogicalOp="Repartition Streams" NodeId="42" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="278.085">
- <OutputList>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="1" ActualRows="145060" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="2" ActualRows="143873" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <Parallelism PartitioningType="Hash">
- <PartitionColumns>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- </PartitionColumns>
- <RelOp AvgRowSize="24" EstimateCPU="25.5503" EstimateIO="159.837" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="36511000" LogicalOp="Index Scan" NodeId="43" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="185.388" TableCardinality="46455000">
- <OutputList>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- </OutputList>
- <RunTimeInformation>
- <RunTimeCountersPerThread Thread="2" ActualRows="150190" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="1" ActualRows="138743" Batches="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row" />
- <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
- </RunTimeInformation>
- <IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="CustomerId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Index="[IX_CustomerAgreement_SourceStore_AgreementId]" IndexKind="NonClustered" />
- <Predicate>
- <ScalarOperator ScalarString="[StoreOpsV170].[Customer].[CustomerAgreement].[IsPrimary]=(1) AND PROBE([Bitmap1118],[StoreOpsV170].[Customer].[CustomerAgreement].[SourceStore],[StoreOpsV170].[Customer].[CustomerAgreement].[AgreementId])">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="IsPrimary" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Intrinsic FunctionName="PROBE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Bitmap1118" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="SourceStore" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[StoreOpsV170]" Schema="[Customer]" Table="[CustomerAgreement]" Column="AgreementId" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Hash>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </TopSort>
- </RelOp>
- </Parallelism>
- </RelOp>
- </Top>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement