<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] FROM [dbo].[Orders] [o] WHERE [o].[CustomerID]=@1 AND [o].[OrderDate]&gt;=@2 AND [o].[OrderDate]&lt;@3 ORDER BY [o].[OrderDate] DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900B863511BF345CCEAF9371B37CDCA60180000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="2" RetrievedFromCache="true" StatementSubTreeCost="0.00338899" StatementEstRows="97.2603" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0x9B9038AE90DD346C" QueryPlanHash="0x9978C91ECE3F2DEA" 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="40" CompileTime="1" CompileCPU="1" CompileMemory="248"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209566" EstimatedPagesCached="52391" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="3770064"></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="Nested Loops" LogicalOp="Inner Join" EstimateRows="97.2603" EstimatedRowsRead="97.2603" EstimateIO="0.003125" EstimateCPU="0.000263986" AvgRowSize="44" EstimatedTotalSubtreeCost="0.00338899" 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" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Merge Interval" LogicalOp="Merge Interval" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><MergeInterval><RelOp NodeId="2" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeWithMismatchedTypes(CONVERT_IMPLICIT(datetime2(7),[@2],0),NULL,(22))"><Intrinsic FunctionName="GetRangeWithMismatchedTypes"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><Convert DataType="datetime2" Scale="7" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@2"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(22)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="23" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ValueVector><ColumnReference Column="Expr1008"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></ValueVector><ScalarOperator ScalarString="GetRangeWithMismatchedTypes(NULL,CONVERT_IMPLICIT(datetime2(7),[@3],0),(10))"><Intrinsic FunctionName="GetRangeWithMismatchedTypes"><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1003"><ScalarOperator><Convert DataType="datetime2" Scale="7" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@3"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(10)"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="0" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></ComputeScalar></RelOp></Concat></RelOp></MergeInterval></RelOp><RelOp NodeId="7" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="97.2603" EstimatedRowsRead="97.2603" EstimateIO="0.003125" EstimateCPU="0.000263986" AvgRowSize="44" EstimatedTotalSubtreeCost="0.00338899" 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="51" 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="CONVERT_IMPLICIT(int,[@1],0)"><Identifier><ColumnReference Column="ConstExpr1001"><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="@1"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix><StartRange ScanType="LT"><RangeColumns><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1011]"><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="GT"><RangeColumns><ColumnReference Database="[DemoShop]" Schema="[dbo]" Table="[Orders]" Alias="[o]" Column="OrderDate"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1010]"><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><ParameterList><ColumnReference Column="@3" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;20260101&apos;" ParameterRuntimeValue="&apos;20260101&apos;"></ColumnReference><ColumnReference Column="@2" ParameterDataType="varchar(8000)" ParameterCompiledValue="&apos;20250101&apos;" ParameterRuntimeValue="&apos;20250101&apos;"></ColumnReference><ColumnReference Column="@1" ParameterDataType="smallint" ParameterCompiledValue="(10332)" ParameterRuntimeValue="(10332)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>