idea Push down operations to spatial databases in Data Management Ideas https://community.esri.com/t5/data-management-ideas/push-down-operations-to-spatial-databases/idi-p/961739 <P>When the geometries are accessed directly from a spatial database then ArcGIS should automatically general the according SQL using appropriate SQL consctucts and SQL/MM functions in the database. A good example here is the spatial join that should be broken down to happen in database whenever possible, e.g. usong ST_INTERSECT or similar spatial join operators of the database. Today the user has to manually type up the SQL query in a query layer to leverage the potentials of spatial databases with ArcGIS.</P><!-- content transformation source ID: 087E0000000Cv45 --> Mon, 29 Aug 2022 21:57:51 GMT TorstenSteinbach 2022-08-29T21:57:51Z Push down operations to spatial databases https://community.esri.com/t5/data-management-ideas/push-down-operations-to-spatial-databases/idi-p/961739 <P>When the geometries are accessed directly from a spatial database then ArcGIS should automatically general the according SQL using appropriate SQL consctucts and SQL/MM functions in the database. A good example here is the spatial join that should be broken down to happen in database whenever possible, e.g. usong ST_INTERSECT or similar spatial join operators of the database. Today the user has to manually type up the SQL query in a query layer to leverage the potentials of spatial databases with ArcGIS.</P><!-- content transformation source ID: 087E0000000Cv45 --> Mon, 29 Aug 2022 21:57:51 GMT https://community.esri.com/t5/data-management-ideas/push-down-operations-to-spatial-databases/idi-p/961739 TorstenSteinbach 2022-08-29T21:57:51Z Re: Push down operations to spatial databases https://community.esri.com/t5/data-management-ideas/push-down-operations-to-spatial-databases/idc-p/961740#M1134 <HTML><HEAD></HEAD><BODY><P>Down vote explained:&nbsp; When doing a spatial join in Arc, using data from a SQL Geography or Geometry table, the join occurs within the application with little to no performance cost. Pushing that same join into a ST_INTERSECT&nbsp;statement, especially when you're doing a join from many features to many features, would kill the database, in fact, you may be waiting for many days for the result to return. </P></BODY></HTML> Wed, 21 Feb 2018 17:56:40 GMT https://community.esri.com/t5/data-management-ideas/push-down-operations-to-spatial-databases/idc-p/961740#M1134 ThomasColson 2018-02-21T17:56:40Z