asked
spatial index in sql server slow
I have below table 1) AreaMap aid int ,location geograpghy ,name varchar(40) with spatial index (SpatialIndex_Area) 2) point pid int, adresGeo geograpghy selecct pid, ( selecct top 1 name from AreaMap WITH(index(SpatialIndex_Area)) where location.STDistance(adresGeo) <50 order by location.STDistance(adresGeo)) as name from point when i run above query process is slows
17 People are following this question.
