<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.4265.3"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT COUNT(*) [order_count],SUM([AmountMinor]) [total_minor] FROM [dbo].[Orders] WHERE [Status]=@1 AND [OrderDate]&gt;=@2 AND [OrderDate]&lt;@3" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x09008DD34BC8C8EA777A5B4610D82FFC58BD0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="32.776" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF10EF42C1DAA9D7B" QueryPlanHash="0x67B6937E21B63D7D" CardinalityEstimationModelVersion="160" BatchModeOnRowStoreUsed="true"><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="49544" CachedPlanSize="48" CompileTime="3" CompileCPU="3" CompileMemory="464"><ThreadStat Branches="1" UsedThreads="16"><ThreadReservation NodeId="0" ReservedThreads="17"></ThreadReservation></ThreadStat><MissingIndexes><MissingIndexGroup Impact="92.6096"><MissingIndex Database="[PlanLab]" Schema="[dbo]" Table="[Orders]"><ColumnGroup Usage="EQUALITY"><Column Name="[Status]" ColumnId="4"></Column></ColumnGroup><ColumnGroup Usage="INEQUALITY"><Column Name="[OrderDate]" ColumnId="3"></Column></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[AmountMinor]" ColumnId="5"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="3072" SerialDesiredMemory="3104" RequiredMemory="49416" DesiredMemory="49544" RequestedMemory="49544" GrantWaitTime="0" MaxQueryMemory="258400" GrantedMemory="49544" MaxUsedMemory="5576" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="20044" EstimatedPagesCached="20044" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="834240"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-08-02T22:26:43.85" ModificationCount="0" SamplingPercent="100" Statistics="[IX_Orders_CustomerId]" Table="[Orders]" Schema="[dbo]" Database="[PlanLab]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-08-02T22:32:47.41" ModificationCount="0" SamplingPercent="4.5428" Statistics="[_WA_Sys_00000004_37A5467C]" Table="[Orders]" Schema="[dbo]" Database="[PlanLab]"></StatisticsInfo><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="HTBUILD" WaitTimeMs="46" WaitCount="30"></Wait><Wait WaitType="LATCH_EX" WaitTimeMs="30" WaitCount="57"></Wait><Wait WaitType="CXSYNC_PORT" WaitTimeMs="26" WaitCount="17"></Wait><Wait WaitType="HTDELETE" WaitTimeMs="9" WaitCount="30"></Wait><Wait WaitType="SESSION_WAIT_STATS_CHILDREN" WaitTimeMs="6" WaitCount="14"></Wait><Wait WaitType="RESERVED_MEMORY_ALLOCATION_EXT" WaitTimeMs="2" WaitCount="364"></Wait></WaitStats><QueryTimeStats ElapsedTime="34" CpuTime="401"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285029" AvgRowSize="19" EstimatedTotalSubtreeCost="32.776" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="33" ActualCPUms="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="19" EstimatedTotalSubtreeCost="32.7475" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="1" Batches="1" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" 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="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Batch"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1012],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1012]=(0) THEN NULL ELSE [Expr1013] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00324152" AvgRowSize="19" EstimatedTotalSubtreeCost="32.7475" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="1" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="0" Batches="0" ActualElapsedms="5" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="0" Batches="0" ActualElapsedms="3" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="1" Batches="1" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="0" Batches="0" ActualElapsedms="5" ActualCPUms="1" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualElapsedms="3" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualElapsedms="2" ActualCPUms="1" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualElapsedms="3" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualElapsedms="4" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualElapsedms="3" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Batch"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="COUNT(*)"><Aggregate Distinct="0" AggType="COUNT*"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="SUM([PlanLab].[dbo].[Orders].[AmountMinor])"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild></HashKeysBuild><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="146644" EstimatedRowsRead="2e+06" EstimateIO="32.1742" EstimateCPU="0.27502" AvgRowSize="33" EstimatedTotalSubtreeCost="32.4493" TableCardinality="2e+06" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Batch"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="5598" Batches="7" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="3270" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="146970" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="5598" Batches="7" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127374" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="3606" Batches="5" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="2180" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="97980" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="5599" Batches="7" ActualElapsedms="24" ActualCPUms="21" ActualScans="1" ActualLogicalReads="3052" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="137172" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="4200" Batches="5" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="1526" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="68586" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="4295" Batches="5" ActualElapsedms="25" ActualCPUms="23" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127374" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="4200" Batches="5" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127374" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="5599" Batches="7" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="3270" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="146970" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="4199" Batches="5" ActualElapsedms="24" ActualCPUms="22" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127374" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="5598" Batches="7" ActualElapsedms="26" ActualCPUms="25" ActualScans="1" ActualLogicalReads="2180" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="98193" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="5599" Batches="7" ActualElapsedms="26" ActualCPUms="24" ActualScans="1" ActualLogicalReads="3706" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="166779" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="4200" Batches="5" ActualElapsedms="26" ActualCPUms="25" ActualScans="1" ActualLogicalReads="1744" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="78597" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="4200" Batches="5" ActualElapsedms="29" ActualCPUms="27" ActualScans="1" ActualLogicalReads="3679" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="166050" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="4200" Batches="5" ActualElapsedms="27" ActualCPUms="25" ActualScans="1" ActualLogicalReads="2616" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="117999" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="5597" Batches="7" ActualElapsedms="26" ActualCPUms="24" ActualScans="1" ActualLogicalReads="3924" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="176813" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="2798" Batches="4" ActualElapsedms="27" ActualCPUms="25" ActualScans="1" ActualLogicalReads="1962" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88395" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Batch"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Batch"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference></DefinedValue></DefinedValues><Object Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Index="[PK_Orders]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[PlanLab].[dbo].[Orders].[OrderDate]&gt;=&apos;2023-01-01 00:00:00.0000000&apos; AND [PlanLab].[dbo].[Orders].[OrderDate]&lt;&apos;2024-01-01 00:00:00.0000000&apos; AND [PlanLab].[dbo].[Orders].[Status]=&apos;CANCELLED&apos;"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2023-01-01 00:00:00.0000000&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2024-01-01 00:00:00.0000000&apos;"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Status"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;CANCELLED&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Hash></RelOp></ComputeScalar></RelOp></Parallelism></RelOp><ParameterList><ColumnReference Column="@3" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;2024-01-01&apos;" ParameterRuntimeValue="&apos;2024-01-01&apos;"></ColumnReference><ColumnReference Column="@2" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;2023-01-01&apos;" ParameterRuntimeValue="&apos;2023-01-01&apos;"></ColumnReference><ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;CANCELLED&apos;" ParameterRuntimeValue="&apos;CANCELLED&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>