<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] FROM [dbo].[Orders] WHERE [OrderDate]&gt;=@1 AND [OrderDate]&lt;@2" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x0900561D3EA50016A91FDBA3019BB8D0EBD90000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="33.859" StatementEstRows="525600" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x7569453B932832CE" QueryPlanHash="0x23014E5C9E086F72" 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="264" CachedPlanSize="24" CompileTime="3" CompileCPU="3" CompileMemory="224"><ThreadStat Branches="1" UsedThreads="16"><ThreadReservation NodeId="0" ReservedThreads="16"></ThreadReservation></ThreadStat><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" RequiredMemory="264" DesiredMemory="264" RequestedMemory="264" GrantWaitTime="0" MaxQueryMemory="255808" GrantedMemory="264" MaxUsedMemory="264"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="20044" EstimatedPagesCached="20044" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="825560"></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="49023" WaitCount="114491"></Wait><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="134" WaitCount="930"></Wait><Wait WaitType="LATCH_EX" WaitTimeMs="82" WaitCount="68"></Wait><Wait WaitType="CXSYNC_PORT" WaitTimeMs="19" WaitCount="17"></Wait></WaitStats><QueryTimeStats ElapsedTime="3836" CpuTime="5175"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="525600" EstimateIO="0" EstimateCPU="1.18972" AvgRowSize="226" EstimatedTotalSubtreeCost="33.859" 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="2797" ActualCPUms="2693" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism><RelOp NodeId="1" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="525600" EstimatedRowsRead="2e+06" EstimateIO="32.1742" EstimateCPU="0.27502" AvgRowSize="226" EstimatedTotalSubtreeCost="32.4493" TableCardinality="2e+06" 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="9798" Batches="0" ActualElapsedms="96" ActualCPUms="93" ActualScans="1" ActualLogicalReads="9718" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="440910" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="9798" Batches="0" ActualElapsedms="14" ActualCPUms="7" ActualScans="1" ActualLogicalReads="872" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="39192" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="29394" Batches="0" ActualElapsedms="21" ActualCPUms="18" ActualScans="1" ActualLogicalReads="1304" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="58788" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="9798" Batches="0" ActualElapsedms="17" ActualCPUms="10" ActualScans="1" ActualLogicalReads="872" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="39192" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="58788" Batches="0" ActualElapsedms="36" ActualCPUms="33" ActualScans="1" ActualLogicalReads="1950" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88182" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="48990" Batches="0" ActualElapsedms="32" ActualCPUms="29" ActualScans="1" ActualLogicalReads="1732" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="78597" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="48990" Batches="0" ActualElapsedms="32" ActualCPUms="28" ActualScans="1" ActualLogicalReads="1732" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="78597" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="48990" Batches="0" ActualElapsedms="35" ActualCPUms="28" ActualScans="1" ActualLogicalReads="1950" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88395" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="54633" Batches="0" ActualElapsedms="35" ActualCPUms="32" ActualScans="1" ActualLogicalReads="1950" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88395" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="48990" Batches="0" ActualElapsedms="36" ActualCPUms="29" ActualScans="1" ActualLogicalReads="1950" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88395" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="58788" Batches="0" ActualElapsedms="41" ActualCPUms="35" ActualScans="1" ActualLogicalReads="2168" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="98193" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="9798" Batches="0" ActualElapsedms="16" ActualCPUms="9" ActualScans="1" ActualLogicalReads="872" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="39192" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="9798" Batches="0" ActualElapsedms="17" ActualCPUms="11" ActualScans="1" ActualLogicalReads="872" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="39402" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="20259" Batches="0" ActualElapsedms="62" ActualCPUms="56" ActualScans="1" ActualLogicalReads="5624" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="254961" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="9798" Batches="0" ActualElapsedms="87" ActualCPUms="80" ActualScans="1" ActualLogicalReads="8625" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="391191" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="48990" Batches="0" ActualElapsedms="32" ActualCPUms="30" ActualScans="1" ActualLogicalReads="1950" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88418" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="0" ActualRows="0" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="0" ActualExecutions="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" 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><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></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;"><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></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp><ParameterList><ColumnReference Column="@2" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;2024-01-01&apos;" ParameterRuntimeValue="&apos;2024-01-01&apos;"></ColumnReference><ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;2023-01-01&apos;" ParameterRuntimeValue="&apos;2023-01-01&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>