<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, Status, AmountMinor, Notes&#xd;&#xa;    FROM dbo.Orders&#xd;&#xa;    WHERE CustomerId = @CustomerId" StatementId="1" StatementCompId="4" StatementType="SELECT" StatementSqlHandle="0x0900B04251BE27366BD2F5723BCF635B32100000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="965578478" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="34.2432" StatementEstRows="666693" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xD8B9B88382956A0A" 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="5" CompileCPU="5" CompileMemory="168"><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="254904" GrantedMemory="264" MaxUsedMemory="264"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="20044" EstimatedPagesCached="20044" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="822232"></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="LATCH_EX" WaitTimeMs="23" WaitCount="35"></Wait><Wait WaitType="CXSYNC_PORT" WaitTimeMs="21" WaitCount="17"></Wait><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="2" WaitCount="105"></Wait></WaitStats><QueryTimeStats ElapsedTime="46" CpuTime="572"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Parallelism" LogicalOp="Gather Streams" EstimateRows="666693" EstimateIO="0" EstimateCPU="1.67394" AvgRowSize="242" EstimatedTotalSubtreeCost="34.2432" 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="Status"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="27" Batches="0" ActualElapsedms="41" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Parallelism><RelOp NodeId="1" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="666693" EstimatedRowsRead="2e+06" EstimateIO="32.1742" EstimateCPU="0.27502" AvgRowSize="246" 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="Status"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="Notes"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="16" ActualRows="1" Batches="0" ActualElapsedms="35" ActualCPUms="33" ActualScans="1" ActualLogicalReads="4142" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="186162" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="15" ActualRows="2" Batches="0" ActualElapsedms="37" ActualCPUms="35" ActualScans="1" ActualLogicalReads="1308" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="58788" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="14" ActualRows="1" Batches="0" ActualElapsedms="34" ActualCPUms="33" 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="1" Batches="0" ActualElapsedms="36" ActualCPUms="35" ActualScans="1" ActualLogicalReads="1308" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="58788" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="12" ActualRows="1" Batches="0" ActualElapsedms="34" ActualCPUms="33" ActualScans="1" ActualLogicalReads="2616" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="117576" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="11" ActualRows="2" Batches="0" ActualElapsedms="35" ActualCPUms="34" ActualScans="1" ActualLogicalReads="4796" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="215766" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="10" ActualRows="2" Batches="0" ActualElapsedms="36" ActualCPUms="35" 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="38" ActualCPUms="37" ActualScans="1" ActualLogicalReads="1281" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="58059" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="8" ActualRows="3" Batches="0" ActualElapsedms="35" ActualCPUms="34" ActualScans="1" ActualLogicalReads="4578" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="205758" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="7" ActualRows="2" Batches="0" ActualElapsedms="36" ActualCPUms="36" ActualScans="1" ActualLogicalReads="1308" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="59024" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="6" ActualRows="0" Batches="0" ActualElapsedms="36" ActualCPUms="35" 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="5" ActualRows="3" Batches="0" ActualElapsedms="35" ActualCPUms="34" ActualScans="1" ActualLogicalReads="4142" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="186375" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="4" ActualRows="2" Batches="0" ActualElapsedms="35" ActualCPUms="35" ActualScans="1" ActualLogicalReads="1962" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="88395" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="3" ActualRows="6" Batches="0" ActualElapsedms="34" ActualCPUms="33" ActualScans="1" ActualLogicalReads="4796" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="215769" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread><RunTimeCountersPerThread Thread="2" ActualRows="0" Batches="0" ActualElapsedms="36" ActualCPUms="36" 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="1" ActualRows="1" Batches="0" ActualElapsedms="35" ActualCPUms="35" 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="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="Status"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="AmountMinor"></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].[CustomerId]=[@CustomerId]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Orders]" Column="CustomerId"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@CustomerId"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Parallelism></RelOp><ParameterList><ColumnReference Column="@CustomerId" ParameterDataType="int" ParameterCompiledValue="(1)" ParameterRuntimeValue="(27)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>