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?
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?