topic Slow Query - REST API in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/slow-query-rest-api/m-p/179509#M7142 <HTML><HEAD></HEAD><BODY><SPAN>Hey all,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Could someone assist me in speeding this query up?</SPAN></BODY></HTML> Thu, 28 Mar 2013 13:27:12 GMT JustinHunter 2013-03-28T13:27:12Z Slow Query - REST API https://community.esri.com/t5/arcgis-enterprise-questions/slow-query-rest-api/m-p/179509#M7142 <HTML><HEAD></HEAD><BODY><SPAN>Hey all,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Could someone assist me in speeding this query up?</SPAN></BODY></HTML> Thu, 28 Mar 2013 13:27:12 GMT https://community.esri.com/t5/arcgis-enterprise-questions/slow-query-rest-api/m-p/179509#M7142 JustinHunter 2013-03-28T13:27:12Z