<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.4265.3"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT [CustomerId],[DisplayName] FROM [dbo].[Customers] WHERE [AccountCode]=@1" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSqlHandle="0x090002A93DB3AF3454698279470B6E8E3E910000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="4.16361" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xAB1C10F8E323AB14" QueryPlanHash="0x719F7AAC194F46C7" 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="1" MemoryGrant="1024" CachedPlanSize="32" CompileTime="10" CompileCPU="10" CompileMemory="272"><Warnings><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(20),[PlanLab].[dbo].[Customers].[AccountCode],0)=[@1]"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Seek Plan" Expression="CONVERT_IMPLICIT(nvarchar(20),[PlanLab].[dbo].[Customers].[AccountCode],0)=N&apos;ACCT-00042000&apos;"></PlanAffectingConvert><MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="1024" GrantedMemory="1024" MaxUsedMemory="0"></MemoryGrantWarning></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="257488" GrantedMemory="1024" MaxUsedMemory="0" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="20044" EstimatedPagesCached="20044" EstimatedAvailableDegreeOfParallelism="8" MaxCompileMemory="833600"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-08-02T22:26:47.29" ModificationCount="0" SamplingPercent="100" Statistics="[IX_Customers_AccountCode]" Table="[Customers]" Schema="[dbo]" Database="[PlanLab]"></StatisticsInfo></OptimizerStatsUsage><WaitStats><Wait WaitType="SOS_SCHEDULER_YIELD" WaitTimeMs="2" WaitCount="85"></Wait></WaitStats><QueryTimeStats ElapsedTime="385" CpuTime="385"></QueryTimeStats><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="135" EstimatedTotalSubtreeCost="4.16361" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="CustomerId"></ColumnReference><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="DisplayName"></ColumnReference></OutputList><MemoryFractions Input="0" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="376" ActualCPUms="376" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="0" OutputMemoryGrant="1024" UsedMemoryGrant="0" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="1"><OuterReferences><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="CustomerId"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Index Scan" LogicalOp="Index Scan" EstimateRows="1" EstimatedRowsRead="1e+06" EstimateIO="2.48016" EstimateCPU="1.10016" AvgRowSize="28" EstimatedTotalSubtreeCost="3.58032" TableCardinality="1e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="CustomerId"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="376" ActualCPUms="376" ActualScans="1" ActualLogicalReads="3373" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1000000" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="CustomerId"></ColumnReference></DefinedValue></DefinedValues><Object Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Index="[IX_Customers_AccountCode]" IndexKind="NonClustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(20),[PlanLab].[dbo].[Customers].[AccountCode],0)=N&apos;ACCT-00042000&apos;"><Compare CompareOp="EQ"><ScalarOperator><Convert DataType="nvarchar" Length="40" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="AccountCode"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;ACCT-00042000&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="5" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="131" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1e+06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="DisplayName"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="DisplayName"></ColumnReference></DefinedValue></DefinedValues><Object Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Index="[PK_Customers]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="CustomerId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[PlanLab].[dbo].[Customers].[CustomerId]"><Identifier><ColumnReference Database="[PlanLab]" Schema="[dbo]" Table="[Customers]" Column="CustomerId"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><ParameterList><ColumnReference Column="@1" ParameterDataType="nvarchar(4000)" ParameterCompiledValue="N&apos;ACCT-00042000&apos;" ParameterRuntimeValue="N&apos;ACCT-00042000&apos;"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>