Select to view content in your preferred language

Slow Query - REST API

598
0
03-28-2013 06:27 AM
JustinHunter
Regular Contributor
Hey all,

I have a database (SQL Server 2008 R2) table that holds the 13 Provinces/Territories and when attempting to do a query to see which Province a point intersects it's taking 26 seconds to give me a result. I ensured that no geometry is being returned. There is a spatial index, though my knowledge of how these work is very limited.

Could someone assist me in speeding this query up?
Tags (2)
0 Kudos
0 Replies