Slow Query - REST API

Discussion created by juhunter on Mar 28, 2013
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?