<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT o.OrderID, o.OrderNumber, o.OrderDate, o.Status, o.ShippingCost&#xa;FROM dbo.Orders AS o&#xa;WHERE o.CustomerID = 10332&#xa;  AND YEAR(o.OrderDate) = 2025&#xa;ORDER BY o.OrderDate DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900E30F6F030146677FF619285A138A22580000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="21.667" StatementEstRows="97.5412" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x0754A559A28607AC" QueryPlanHash="0x095B8EF38A37247B" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="4" MemoryGrant="2152" CachedPlanSize="32" CompileTime="2" CompileCPU="2" CompileMemory="304"><ThreadStat Branches="1" UsedThreads="4"><ThreadReservation NodeId="0" ReservedThreads="4"></ThreadReservation></ThreadStat><MissingIndexes><MissingIndexGroup Impact="99.7922"><MissingIndex Database="[DemoShop]" Schema="[dbo]" Table="[Orders]"><ColumnGroup Usage="EQUALITY"><Column Name="[CustomerID]" ColumnId="3"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><Warnings><MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="2152" GrantedMemory="2152" MaxUsedMemory="80"></MemoryGrantWarning></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="2120" DesiredMemory="2152" RequestedMemory="2152" GrantWaitTime="0" MaxQueryMemory="972472" GrantedMemory="2152" MaxUsedMemory="80" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209566" EstimatedPagesCached="52391" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="3811008"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-10-06T12:02:48.82" ModificationCount="0" SamplingPercent="100" Statistics="[UQ_Orders_OrderNumber]" Table="[Orders]" Schema="[dbo]" Database="[DemoShop]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-06T12:02:52.18" ModificationCount="0" SamplingPercent="100" Statistics="[IX_Orders_Status]" Table="[Orders]" Schema="[dbo]" Database="[DemoShop]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-06T12:03:06.34" ModificationCount="0" SamplingPercent="100" Statistics="[st_Orders_OrderDate]" Table="[Orders]" Schema="[dbo]" Database="[DemoShop]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-10-06T12:02:49.81" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_4316F928]" Table="[Orders]" Schema="[dbo]" Database="[DemoShop]"></StatisticsInfo></OptimizerStatsUsage><QueryTimeStats ElapsedTime="59" CpuTime="233"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="97.5412" EstimateIO="0.0112613" EstimateCPU="0.00110554" AvgRowSize="44" EstimatedTotalSubtreeCost="21.667" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderID"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderNumber"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="Status"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="ShippingCost"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="51" Batches="0" ActualElapsedms="59" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="520" OutputMemoryGrant="136" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="97.5412" EstimateIO="0" EstimateCPU="0.0287966" AvgRowSize="44" EstimatedTotalSubtreeCost="21.6547" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderID"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderNumber"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="Status"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="ShippingCost"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="51" Batches="0" ActualElapsedms="59" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="97.5412" EstimatedRowsRead="2.4e+06" EstimateIO="19.1298" EstimateCPU="1.32008" AvgRowSize="48" EstimatedTotalSubtreeCost="20.4499" TableCardinality="2.4e+06" Parallel="1" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderID"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderNumber"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="Status"></ColumnReference><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="ShippingCost"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="4" ActualRows="14" Batches="0" ActualElapsedms="57" ActualCPUms="57" ActualScans="1" ActualLogicalReads="6270" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="577690" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="16" Batches="0" ActualElapsedms="57" ActualCPUms="57" ActualScans="1" ActualLogicalReads="6593" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="606562" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="8" Batches="0" ActualElapsedms="59" ActualCPUms="59" ActualScans="1" ActualLogicalReads="6897" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="636399" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="1" ActualRows="13" Batches="0" ActualElapsedms="59" ActualCPUms="59" ActualScans="1" ActualLogicalReads="6270" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="579345" 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="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderNumber"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="Status"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="ShippingCost"></ColumnReference></DefinedValue></DefinedValues><Object Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Index="[PK_Orders]" Alias="[o]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[DemoShop].[dbo].[Orders].[CustomerID] as [o].[CustomerID]=(10332) AND datepart(year,[DemoShop].[dbo].[Orders].[OrderDate] as [o].[OrderDate])=(2025)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="CustomerID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10332)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(2025)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp></Sort></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>