<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.4265.3"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT OrderId, OrderDate, Notes&#xa;FROM dbo.Orders WITH (FORCESEEK, INDEX(IX_Orders_OrderDate_Narrow))&#xa;WHERE OrderDate &gt;= &apos;2023-01-01&apos; AND OrderDate &lt; &apos;2024-01-01&apos;" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x09006987876BA071A663ECC07684B23341E20000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="230.302" StatementEstRows="525600" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4C136CECA3E6BE34" QueryPlanHash="0x4384B2CCAE028230" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="false" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="16" MemoryGrant="53512" CachedPlanSize="48" CompileTime="2" CompileCPU="2" CompileMemory="200"><ThreadStat Branches="2" UsedThreads="17"><ThreadReservation NodeId="0" ReservedThreads="32"></ThreadReservation></ThreadStat><MissingIndexes><MissingIndexGroup Impact="92.3832"><MissingIndex Database="[PlanLab]" Schema="[dbo]" Table="[Orders]"><ColumnGroup Usage="INEQUALITY"><Column Name="[OrderDate]" ColumnId="3"></Column></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[Notes]" ColumnId="6"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="45184" RequiredMemory="8840" DesiredMemory="53512" RequestedMemory="53512" GrantWaitTime="0" MaxQueryMemory="255808" GrantedMemory="53512" MaxUsedMemory="30848" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="20044" EstimatedPagesCached="20044" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="825872"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-08-02T22:26:45.31" ModificationCount="0" SamplingPercent="100" Statistics="[IX_Orders_OrderDate]" Table="[Orders]" Schema="[dbo]" Database="[PlanLab]"></StatisticsInfo></OptimizerStatsUsage><WaitStats><Wait WaitType="CXPACKET" WaitTimeMs="67197" WaitCount="129925"></Wait><Wait WaitType="CXSYNC_PORT" WaitTimeMs="317" WaitCount="34"></Wait><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="181" WaitCount="1109"></Wait><Wait WaitType="CXSYNC_CONSUMER" WaitTimeMs="8" WaitCount="15"></Wait><Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="8" WaitCount="3857"></Wait></WaitStats><QueryTimeStats ElapsedTime="4954" CpuTime="7720"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="525600" EstimateIO="0" EstimateCPU="1.18972" AvgRowSize="226" EstimatedTotalSubtreeCost="230.302" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="525600" Batches="0" ActualElapsedms="3853" ActualCPUms="3375" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="525600" EstimateIO="0" EstimateCPU="0.274626" AvgRowSize="226" EstimatedTotalSubtreeCost="229.113" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="32850" Batches="0" ActualElapsedms="381" ActualCPUms="111" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="32850" Batches="0" ActualElapsedms="355" ActualCPUms="86" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="32850" Batches="0" ActualElapsedms="380" ActualCPUms="111" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="32850" Batches="0" ActualElapsedms="387" ActualCPUms="117" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="32850" Batches="0" ActualElapsedms="377" ActualCPUms="108" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="32850" Batches="0" ActualElapsedms="379" ActualCPUms="110" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="32850" Batches="0" ActualElapsedms="375" ActualCPUms="106" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="32850" Batches="0" ActualElapsedms="383" ActualCPUms="113" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="32850" Batches="0" ActualElapsedms="382" ActualCPUms="113" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="32850" Batches="0" ActualElapsedms="371" ActualCPUms="103" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="32850" Batches="0" ActualElapsedms="382" ActualCPUms="114" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="32850" Batches="0" ActualElapsedms="374" ActualCPUms="105" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="32850" Batches="0" ActualElapsedms="380" ActualCPUms="112" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="32850" Batches="0" ActualElapsedms="386" ActualCPUms="117" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="32850" Batches="0" ActualElapsedms="376" ActualCPUms="106" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="32850" Batches="0" ActualElapsedms="385" ActualCPUms="113" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="525600" EstimateIO="4.43131" EstimateCPU="2.32587" AvgRowSize="22" EstimatedTotalSubtreeCost="10.0165" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="19" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="32850" Batches="0" ActualElapsedms="286" ActualCPUms="17" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="32850" Batches="0" ActualElapsedms="288" ActualCPUms="19" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="19" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="32850" Batches="0" ActualElapsedms="288" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="32850" Batches="0" ActualElapsedms="288" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="32850" Batches="0" ActualElapsedms="287" ActualCPUms="19" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="32850" Batches="0" ActualElapsedms="288" ActualCPUms="21" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="32850" Batches="0" ActualElapsedms="288" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="32850" Batches="0" ActualElapsedms="289" ActualCPUms="20" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="32850" Batches="0" ActualElapsedms="288" ActualCPUms="19" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="32850" Batches="0" ActualElapsedms="290" ActualCPUms="17" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="3304" OutputMemoryGrant="2920" UsedMemoryGrant="1888" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="0" InputMemoryGrant="0" OutputMemoryGrant="0" UsedMemoryGrant="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="4" PhysicalOp="Parallelism" LogicalOp="Distribute Streams" EstimateRows="525600" EstimateIO="0" EstimateCPU="1.66601" AvgRowSize="22" EstimatedTotalSubtreeCost="3.2593" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="2" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="2" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="2" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="32850" Batches="0" ActualElapsedms="271" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="32850" Batches="0" ActualElapsedms="271" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="32850" Batches="0" ActualElapsedms="271" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="32850" Batches="0" ActualElapsedms="271" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="32850" Batches="0" ActualElapsedms="270" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="32850" Batches="0" ActualElapsedms="271" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="32850" Batches="0" ActualElapsedms="271" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="32850" Batches="0" ActualElapsedms="272" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="32850" Batches="0" ActualElapsedms="273" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="32850" Batches="0" ActualElapsedms="275" ActualCPUms="2" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism PartitioningType="RoundRobin"><RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="525600" EstimatedRowsRead="525600" EstimateIO="1.01498" EstimateCPU="0.578317" AvgRowSize="22" EstimatedTotalSubtreeCost="1.59329" TableCardinality="2e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="525600" Batches="0" ActualElapsedms="149" ActualCPUms="134" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OuterReferences><RelOp NodeId="6" PhysicalOp="Merge Interval" LogicalOp="Merge Interval" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="25" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><MergeInterval><RelOp NodeId="7" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="25" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="25" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeWithMismatchedTypes(&apos;2023-01-01 00:00:00.0000000&apos;,NULL,(22))"><Intrinsic FunctionName="GetRangeWithMismatchedTypes"><ScalarOperator><Const ConstValue="&apos;2023-01-01 00:00:00.0000000&apos;"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(22)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="25" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeWithMismatchedTypes(NULL,&apos;2024-01-01 00:00:00.0000000&apos;,(10))"><Intrinsic FunctionName="GetRangeWithMismatchedTypes"><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2024-01-01 00:00:00.0000000&apos;"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp></Concat></RelOp></MergeInterval></RelOp><RelOp NodeId="12" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="525600" EstimatedRowsRead="525600" EstimateIO="1.01498" EstimateCPU="0.578317" AvgRowSize="22" EstimatedTotalSubtreeCost="1.59329" TableCardinality="2e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="1" ActualRows="525600" Batches="0" ActualElapsedms="95" ActualCPUms="95" ActualScans="1" ActualLogicalReads="1374" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="525600" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="1" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></DefinedValue></DefinedValues><Object Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Index="[IX_Orders_OrderDate_Narrow]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GT"><RangeColumns><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1008]"><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LT"><RangeColumns><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1009]"><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Parallelism></RelOp></Sort></RelOp><RelOp NodeId="14" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="211" EstimatedTotalSubtreeCost="218.822" TableCardinality="2e+06" Parallel="1" EstimateRebinds="525599" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="32850" Batches="0" ActualElapsedms="67" ActualCPUms="67" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="32850" Batches="0" ActualElapsedms="52" ActualCPUms="52" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="32850" Batches="0" ActualElapsedms="66" ActualCPUms="66" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="32850" Batches="0" ActualElapsedms="73" ActualCPUms="73" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="32850" Batches="0" ActualElapsedms="65" ActualCPUms="65" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="32850" Batches="0" ActualElapsedms="65" ActualCPUms="65" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="32850" Batches="0" ActualElapsedms="63" ActualCPUms="63" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="32850" Batches="0" ActualElapsedms="68" ActualCPUms="68" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="32850" Batches="0" ActualElapsedms="67" ActualCPUms="67" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="32850" Batches="0" ActualElapsedms="62" ActualCPUms="62" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="32850" Batches="0" ActualElapsedms="69" ActualCPUms="69" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="32850" Batches="0" ActualElapsedms="62" ActualCPUms="62" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="32850" Batches="0" ActualElapsedms="66" ActualCPUms="66" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="32850" Batches="0" ActualElapsedms="71" ActualCPUms="71" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="32850" Batches="0" ActualElapsedms="64" ActualCPUms="64" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="32850" Batches="0" ActualElapsedms="70" ActualCPUms="70" ActualScans="0" ActualLogicalReads="94426" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="32850" ActualEndOfScans="0" ActualExecutions="32850" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="1" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></ColumnReference></DefinedValue></DefinedValues><Object Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Index="[PK_Orders]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[PlanLab].[dbo].[Orders].[OrderId]"><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderId"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Parallelism></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>