All Questions
Tagged with sql-server-spatial performance
3 questions
2
votes
1
answer
944
views
MSSQL Spatial Query (View) is Slow in ArcMap
I created the following view in Microsoft SQL Server 2008 R2:
CREATE VIEW test AS
SELECT
p.id,
p.shape
FROM
p INNER JOIN r ON p.shape.STIntersects(r.shape) = 1
WHERE
r.Name = '...
- 437
0
votes
0
answers
588
views
MS SQL Server STEnvelope() performance
Using MS SQL Server 2012, when we write a query with
select GEOM.STEnvelope() from table
where table holds approx. 4000 native SQL Server line geometries of type geometry, with 2/6/180 points min/...
- 5,237
4
votes
1
answer
2k
views
Speeding up SQL spatial query gives spatial index error?
I am trying to split polylines by points which have a small buffer around them. Currently I have over 370,000 lines and 320,000 nodes and the query is running really slowly (I've left it for 3 days ...
- 65.4k