<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 CONVERT([varchar](10),[OrderDate],(120))=@1" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x09008CD4D1FB38DCC43CC718EFF11C39D7910000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="32.6228" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xDA34389932A93B76" QueryPlanHash="0x2A69D517BCA051E4" 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="32" CompileTime="4" CompileCPU="3" CompileMemory="320"><ThreadStat Branches="1" UsedThreads="16"><ThreadReservation NodeId="0" ReservedThreads="16"></ThreadReservation></ThreadStat><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(varchar(10),[PlanLab].[dbo].[Orders].[OrderDate],120)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT(varchar(10),[PlanLab].[dbo].[Orders].[OrderDate],120)=[@1]"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT(varchar(10),[PlanLab].[dbo].[Orders].[OrderDate],120)=&apos;2023-06-15&apos;"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" RequiredMemory="264" DesiredMemory="264" RequestedMemory="264" GrantWaitTime="0" MaxQueryMemory="257536" GrantedMemory="264" MaxUsedMemory="264"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="20044" EstimatedPagesCached="20044" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="828928"></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:26:45.31" ModificationCount="0" SamplingPercent="100" Statistics="[IX_Orders_OrderDate]" Table="[Orders]" Schema="[dbo]" Database="[PlanLab]"></StatisticsInfo></OptimizerStatsUsage><WaitStats><Wait WaitType="CXSYNC_PORT" WaitTimeMs="28" WaitCount="17"></Wait><Wait WaitType="LATCH_EX" WaitTimeMs="22" WaitCount="27"></Wait><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="10" WaitCount="451"></Wait></WaitStats><QueryTimeStats ElapsedTime="173" CpuTime="2500"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="19" EstimatedTotalSubtreeCost="32.6228" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1011],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1011]=(0) THEN NULL ELSE [Expr1012] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></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="Expr1012"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="32.6228" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="171" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></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><RelOp NodeId="2" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0285021" AvgRowSize="15" EstimatedTotalSubtreeCost="32.6228" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1440" Batches="0" ActualElapsedms="171" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism><RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimatedRowsRead="2e+06" EstimateIO="32.1742" EstimateCPU="0.27502" AvgRowSize="22" EstimatedTotalSubtreeCost="32.4493" TableCardinality="2e+06" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="0" Batches="0" ActualElapsedms="155" ActualCPUms="154" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127374" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="0" Batches="0" ActualElapsedms="159" ActualCPUms="154" ActualScans="1" ActualLogicalReads="3706" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="166566" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="0" Batches="0" ActualElapsedms="159" ActualCPUms="157" ActualScans="1" ActualLogicalReads="1526" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="68586" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="13" ActualRows="0" Batches="0" ActualElapsedms="153" ActualCPUms="152" ActualScans="1" ActualLogicalReads="3706" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="166566" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="0" Batches="0" ActualElapsedms="162" ActualCPUms="161" ActualScans="1" ActualLogicalReads="1526" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="68586" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="0" Batches="0" ActualElapsedms="162" ActualCPUms="161" ActualScans="1" ActualLogicalReads="1526" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="68586" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="0" Batches="0" ActualElapsedms="153" ActualCPUms="153" ActualScans="1" ActualLogicalReads="2616" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="117789" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="9" ActualRows="0" Batches="0" ActualElapsedms="162" ActualCPUms="161" ActualScans="1" ActualLogicalReads="1526" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="68796" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="0" Batches="0" ActualElapsedms="168" ActualCPUms="167" ActualScans="1" ActualLogicalReads="2589" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="116847" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="0" Batches="0" ActualElapsedms="155" ActualCPUms="154" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127587" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualElapsedms="150" ActualCPUms="150" ActualScans="1" ActualLogicalReads="3706" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="166779" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="5" ActualRows="1440" Batches="0" ActualElapsedms="153" ActualCPUms="153" ActualScans="1" ActualLogicalReads="2834" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="127587" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="0" Batches="0" ActualElapsedms="150" ActualCPUms="149" ActualScans="1" ActualLogicalReads="3488" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="156981" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="0" Batches="0" ActualElapsedms="152" ActualCPUms="152" ActualScans="1" ActualLogicalReads="2616" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="117789" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualElapsedms="150" ActualCPUms="150" ActualScans="1" ActualLogicalReads="3488" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="157004" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="0" Batches="0" ActualElapsedms="155" ActualCPUms="155" ActualScans="1" ActualLogicalReads="3924" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="176577" 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="AmountMinor"></ColumnReference></DefinedValue></DefinedValues><Object Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Index="[PK_Orders]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="CONVERT(varchar(10),[PlanLab].[dbo].[Orders].[OrderDate],120)=&apos;2023-06-15&apos;"><Compare CompareOp="EQ"><ScalarOperator><Convert DataType="varchar" Length="10" Style="120" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="OrderDate"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="&apos;2023-06-15&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;2023-06-15&apos;" ParameterRuntimeValue="&apos;2023-06-15&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>