<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="0.00362155" StatementEstRows="97.5412" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x0754A559A28607AC" QueryPlanHash="0xADD48AF9AA493EC4" 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="1" CachedPlanSize="24" CompileTime="1" CompileCPU="1" CompileMemory="248"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209566" EstimatedPagesCached="52391" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="3780296"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><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="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="97.5412" EstimatedRowsRead="173" EstimateIO="0.00327425" EstimateCPU="0.0003473" AvgRowSize="44" EstimatedTotalSubtreeCost="0.00362155" TableCardinality="2.4e+06" 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><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="51" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="173" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="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="[IX_Orders_CustomerID_OrderDate]" Alias="[o]" IndexKind="NonClustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="CustomerID"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(10332)"><Const ConstValue="(10332)"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="datepart(year,[DemoShop].[dbo].[Orders].[OrderDate] as [o].[OrderDate])=(2025)"><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></Predicate></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>