https://community.esri.com/t5/arcgis-pro-ideas/spatial-defragmentation-gp-tool-to-optimize-data/idi-p/1366475 <P>Spatial queries are notoriously slow:&nbsp;<A href="https://community.esri.com/t5/arcgis-enterprise-questions/why-are-spatial-sql-queries-so-much-slower-than/m-p/1274156" target="_self">Why are spatial SQL queries so much slower than Select By Location?</A></P><P>It sounds like it's possible to optimize the row order of features in a FC to improve spatial query performance:</P><BLOCKQUOTE><P>From&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/1060">@VinceAngelo</a>&nbsp;</P><P>[When exporting a feature class, you can develop a workflow to] query in spatial index order, which would optimize created feature order, which should result in improved performance with every query. And if you're going to do that, then you should also optimize your coordinate reference to reduce storage and <STRONG>improve query performance.</STRONG></P><P><A href="https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082" target="_blank" rel="nofollow noopener">https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082</A></P></BLOCKQUOTE><P>Most of us are unfamiliar with such techniques and how to implement them. Could an OOTB tool be added to ArcGIS Pro that would optimize row order in a feature class for improved spatial query performance?</P><P>Related SDO_GEOMETRY post:&nbsp;<A href="https://forums.oracle.com/ords/apexds/post/optimize-row-order-for-improved-query-spatial-index-perform-6689" target="_self">Optimize row order for improved query/spatial index performance</A></P> Thu, 18 Jan 2024 09:52:33 GMT Bud 2024-01-18T09:52:33Z https://community.esri.com/t5/arcgis-pro-ideas/spatial-defragmentation-gp-tool-to-optimize-data/idi-p/1366475 <P>Spatial queries are notoriously slow:&nbsp;<A href="https://community.esri.com/t5/arcgis-enterprise-questions/why-are-spatial-sql-queries-so-much-slower-than/m-p/1274156" target="_self">Why are spatial SQL queries so much slower than Select By Location?</A></P><P>It sounds like it's possible to optimize the row order of features in a FC to improve spatial query performance:</P><BLOCKQUOTE><P>From&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/1060">@VinceAngelo</a>&nbsp;</P><P>[When exporting a feature class, you can develop a workflow to] query in spatial index order, which would optimize created feature order, which should result in improved performance with every query. And if you're going to do that, then you should also optimize your coordinate reference to reduce storage and <STRONG>improve query performance.</STRONG></P><P><A href="https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082" target="_blank" rel="nofollow noopener">https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082</A></P></BLOCKQUOTE><P>Most of us are unfamiliar with such techniques and how to implement them. Could an OOTB tool be added to ArcGIS Pro that would optimize row order in a feature class for improved spatial query performance?</P><P>Related SDO_GEOMETRY post:&nbsp;<A href="https://forums.oracle.com/ords/apexds/post/optimize-row-order-for-improved-query-spatial-index-perform-6689" target="_self">Optimize row order for improved query/spatial index performance</A></P> Thu, 18 Jan 2024 09:52:33 GMT https://community.esri.com/t5/arcgis-pro-ideas/spatial-defragmentation-gp-tool-to-optimize-data/idi-p/1366475 Bud 2024-01-18T09:52:33Z https://community.esri.com/t5/arcgis-pro-ideas/spatial-defragmentation-gp-tool-to-optimize-data/idc-p/1371532#M28075 <P>Possibly related: <A href="https://community.esri.com/t5/geodatabase-questions/sort-gp-tool-intended-use-case-for-sorting-shape/td-p/1371525" target="_self">Sort GP tool — Intended use case for sorting SHAPE field?</A></P> Thu, 18 Jan 2024 09:51:21 GMT https://community.esri.com/t5/arcgis-pro-ideas/spatial-defragmentation-gp-tool-to-optimize-data/idc-p/1371532#M28075 Bud 2024-01-18T09:51:21Z