<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.599" Build="17.0.4075.5"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT TOP(1) [t].[Id]&#xa;FROM [Technicians] AS [t]&#xa;WHERE [t].[TerritoryId] = @territoryId AND [t].[IsAvailable] = CAST(1 AS bit)&#xa;ORDER BY [t].[Location].STDistance(@jobLocation)" StatementId="1" StatementCompId="5" StatementType="SELECT" StatementSqlHandle="0x0900D1289DAC4563B6336F37B20D356BB7D90000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="2.29917" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x4EA277A47CBA300C" QueryPlanHash="0x0A1E35A2BC305794" CardinalityEstimationModelVersion="170"><StatementSetOptions QUOTED_IDENTIFIER="true" 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="181" CompileCPU="41" CompileMemory="288"><MissingIndexes><MissingIndexGroup Impact="89.5592"><MissingIndex Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]"><ColumnGroup Usage="EQUALITY"><Column Name="[TerritoryId]" ColumnId="3"></Column><Column Name="[IsAvailable]" ColumnId="4"></Column></ColumnGroup><ColumnGroup Usage="INCLUDE"><Column Name="[Location]" ColumnId="6"></Column></ColumnGroup></MissingIndex></MissingIndexGroup></MissingIndexes><MemoryGrantInfo SerialRequiredMemory="16" SerialDesiredMemory="24" RequiredMemory="16" DesiredMemory="24" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="4430688" GrantedMemory="1024" MaxUsedMemory="16" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="187808" EstimatedPagesCached="164332" EstimatedAvailableDegreeOfParallelism="7" MaxCompileMemory="17851240"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-09-08T19:15:27.03" ModificationCount="0" SamplingPercent="47.0765" Statistics="[_WA_Sys_00000004_48CFD27E]" Table="[Technicians]" Schema="[dbo]" Database="[SpatialDispatchPlan]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-09-08T19:15:26.94" ModificationCount="0" SamplingPercent="47.0765" Statistics="[_WA_Sys_00000003_48CFD27E]" Table="[Technicians]" Schema="[dbo]" Database="[SpatialDispatchPlan]"></StatisticsInfo></OptimizerStatsUsage><QueryTimeStats ElapsedTime="40" CpuTime="40"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="TopN Sort" EstimateRows="1" EstimateRowsWithoutRowGoal="408.236" EstimateIO="0.0112613" EstimateCPU="0.00562357" AvgRowSize="19" EstimatedTotalSubtreeCost="2.29917" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Id"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="40" ActualCPUms="40" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="1024" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TopSort Distinct="0" Rows="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1001"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="408.236" EstimateRowsWithoutRowGoal="408.236" EstimateIO="0" EstimateCPU="4.08236e-05" AvgRowSize="19" EstimatedTotalSubtreeCost="2.28229" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Id"></ColumnReference><ColumnReference Column="Expr1001"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="334" Batches="0" ActualElapsedms="39" ActualCPUms="39" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1001"></ColumnReference><ScalarOperator ScalarString="[SpatialDispatchPlan].[dbo].[Technicians].[Location] as [t].[Location].STDistance([@jobLocation])"><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="STDistance"></CLRFunction><ScalarOperator><Identifier><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Location"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@jobLocation"></ColumnReference></Identifier></ScalarOperator></UDTMethod></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="408.236" EstimatedRowsRead="200000" EstimateIO="1.88609" EstimateCPU="0.220157" AvgRowSize="4044" EstimatedTotalSubtreeCost="2.10624" TableCardinality="200000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Id"></ColumnReference><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Location"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="334" Batches="0" ActualElapsedms="37" ActualCPUms="37" ActualScans="1" ActualLogicalReads="2554" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="200000" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="Location"></ColumnReference></DefinedValue></DefinedValues><Object Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Index="[PK_Technicians]" Alias="[t]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[SpatialDispatchPlan].[dbo].[Technicians].[TerritoryId] as [t].[TerritoryId]=[@territoryId] AND [SpatialDispatchPlan].[dbo].[Technicians].[IsAvailable] as [t].[IsAvailable]=(1)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="TerritoryId"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@territoryId"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Technicians]" Alias="[t]" Column="IsAvailable"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></TopSort></RelOp><ParameterList><ColumnReference Column="@jobLocation" ParameterDataType="sys.geography" ParameterRuntimeValue="POINT (-75.683967 41.360406)"></ColumnReference><ColumnReference Column="@territoryId" ParameterDataType="int" ParameterRuntimeValue="(17)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>