<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.599" Build="17.0.4075.5"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT [t].[Id], [t].[Name]&#xa;FROM [Territories] AS [t]&#xa;WHERE [t].[Boundary].STContains(@jobLocation) = CAST(1 AS bit)" StatementId="1" StatementCompId="5" StatementType="SELECT" StatementSqlHandle="0x09009DEF18CCE9404EC428FFBD50722518010000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="3.03198" StatementEstRows="4000" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xB6C3DB3180751B8C" QueryPlanHash="0x2B8AABAC2490E31C" 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="2016" CachedPlanSize="56" CompileTime="8" CompileCPU="8" CompileMemory="400"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="2016" RequiredMemory="1024" DesiredMemory="2016" RequestedMemory="2016" GrantWaitTime="0" MaxQueryMemory="4430688" GrantedMemory="2016" MaxUsedMemory="696" LastRequestedMemory="0" IsMemoryGrantFeedbackAdjusted="No: First Execution"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="187808" EstimatedPagesCached="164332" EstimatedAvailableDegreeOfParallelism="7" MaxCompileMemory="17847816"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2026-09-08T19:15:25.86" ModificationCount="0" SamplingPercent="99.073" Statistics="[SIX_Territories_Boundary]" Table="[extended_index_1253579504_384000]" Schema="[sys]" Database="[SpatialDispatchPlan]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-09-08T19:15:25.62" ModificationCount="0" SamplingPercent="100" Statistics="[PK_Territories]" Table="[Territories]" Schema="[dbo]" Database="[SpatialDispatchPlan]"></StatisticsInfo><StatisticsInfo LastUpdate="2026-09-08T19:15:31.17" ModificationCount="0" SamplingPercent="99.073" Statistics="[_WA_Sys_00000003_4D94879B]" Table="[extended_index_1253579504_384000]" Schema="[sys]" Database="[SpatialDispatchPlan]"></StatisticsInfo></OptimizerStatsUsage><QueryTimeStats ElapsedTime="1" CpuTime="1"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="4000" EstimateIO="0" EstimateCPU="0.0028118" AvgRowSize="115" EstimatedTotalSubtreeCost="3.03198" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Id"></ColumnReference><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Name"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualElapsedms="1" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Boundary"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="672.68" EstimateIO="0" EstimateCPU="0.0028118" AvgRowSize="4141" EstimatedTotalSubtreeCost="2.35536" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Id"></ColumnReference><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Name"></ColumnReference><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Boundary"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualElapsedms="1" ActualCPUms="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="6726.8" EstimateIO="0" EstimateCPU="0.119264" AvgRowSize="11" EstimatedTotalSubtreeCost="0.825335" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="2016" OutputMemoryGrant="2016" UsedMemoryGrant="696" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference></HashKeysBuild><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="6726.8" EstimateIO="0" EstimateCPU="0.028118" AvgRowSize="11" EstimatedTotalSubtreeCost="0.706071" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Column="Id"></ColumnReference><ColumnReference Column="LimitId"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OuterReferences><RelOp NodeId="6" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="1000" EstimateIO="0" EstimateCPU="0.00100016" AvgRowSize="17" EstimatedTotalSubtreeCost="0.00100016" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Id"></ColumnReference><ColumnReference Column="LimitId"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="LimitId"></ColumnReference></DefinedValue></DefinedValues><Object Table="[GeodeticTessellation]"></Object><ParameterList><ScalarOperator ScalarString="[@jobLocation]"><Identifier><ColumnReference Column="@jobLocation"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(768)"><Const ConstValue="(768)"></Const></ScalarOperator><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><RelOp NodeId="7" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="6.7268" EstimatedRowsRead="6.7268" EstimateIO="0.003125" EstimateCPU="0.000164399" AvgRowSize="11" EstimatedTotalSubtreeCost="0.676953" TableCardinality="459538" Parallel="0" EstimateRebinds="994.377" EstimateRewinds="4.62341" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="8" ActualLogicalReads="24" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="24" ActualEndOfScans="8" ActualExecutions="8" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference></DefinedValue></DefinedValues><Object Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Index="[SIX_Territories_Boundary]" TableReferenceId="-1" IndexKind="Spatial" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="Id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Id]"><Identifier><ColumnReference Column="Id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LE"><RangeColumns><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="Id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[LimitId]"><Identifier><ColumnReference Column="LimitId"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Hash></RelOp><RelOp NodeId="8" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4141" EstimatedTotalSubtreeCost="1.52721" TableCardinality="40000" Parallel="0" EstimateRebinds="671.68" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Id"></ColumnReference><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Name"></ColumnReference><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Boundary"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="54" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="24" ActualEndOfScans="0" ActualExecutions="24" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Boundary"></ColumnReference></DefinedValue></DefinedValues><Object Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Index="[PK_Territories]" Alias="[t]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[SpatialDispatchPlan].[sys].[extended_index_1253579504_384000].[pk0]"><Identifier><ColumnReference Database="[SpatialDispatchPlan]" Schema="[sys]" Table="[extended_index_1253579504_384000]" Column="pk0"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="9" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00100068" AvgRowSize="9" EstimatedTotalSubtreeCost="0.67381" Parallel="0" EstimateRebinds="646.744" EstimateRewinds="24.9361" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="24" ActualRewinds="0" ActualEndOfScans="18" ActualExecutions="24" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="10" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="0.000672837" Parallel="0" EstimateRebinds="0" EstimateRewinds="671.68" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="6" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp><Predicate><ScalarOperator ScalarString="[SpatialDispatchPlan].[dbo].[Territories].[Boundary] as [t].[Boundary].STContains([@jobLocation])=(1)"><Compare CompareOp="EQ"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="STContains"></CLRFunction><ScalarOperator><Identifier><ColumnReference Database="[SpatialDispatchPlan]" Schema="[dbo]" Table="[Territories]" Alias="[t]" Column="Boundary"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@jobLocation"></ColumnReference></Identifier></ScalarOperator></UDTMethod></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp><ParameterList><ColumnReference Column="@jobLocation" ParameterDataType="sys.geography" ParameterRuntimeValue="POINT (-75.683967 41.360406)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>