https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-optimize-feature-order-for-improved-fc/idi-p/1281146 <P>Back in 2011,&nbsp;Vince Angelo&nbsp;mentioned the following workflow for improving feature class performance:</P><BLOCKQUOTE><P><SPAN>[When exporting a feature class, you can develop a workflow to] query in spatial index order, which would optimize&nbsp;</SPAN><SPAN>created feature order, which should result in improved performance with every query. And if you're&nbsp;</SPAN><SPAN>going to do that, then you should also optimize your coordinate reference to reduce storage and&nbsp;</SPAN><SPAN>improve query performance.</SPAN></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">https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082</A>&nbsp;</P></BLOCKQUOTE><P><SPAN>If I understand correctly, that optimization isn’t done automatically when exporting/importing a feature class.</SPAN></P><P><SPAN>Could a geoprocessing tool be added that would perform that workflow out of the box? Or provide an option to do that as part of the export GP tool?</SPAN></P> Fri, 21 Apr 2023 04:28:10 GMT Bud 2023-04-21T04:28:10Z https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-optimize-feature-order-for-improved-fc/idi-p/1281146 <P>Back in 2011,&nbsp;Vince Angelo&nbsp;mentioned the following workflow for improving feature class performance:</P><BLOCKQUOTE><P><SPAN>[When exporting a feature class, you can develop a workflow to] query in spatial index order, which would optimize&nbsp;</SPAN><SPAN>created feature order, which should result in improved performance with every query. And if you're&nbsp;</SPAN><SPAN>going to do that, then you should also optimize your coordinate reference to reduce storage and&nbsp;</SPAN><SPAN>improve query performance.</SPAN></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">https://community.esri.com/t5/data-management-questions/maintain-objectid-values-when-importing-a/m-p/263688/highlight/true#M15082</A>&nbsp;</P></BLOCKQUOTE><P><SPAN>If I understand correctly, that optimization isn’t done automatically when exporting/importing a feature class.</SPAN></P><P><SPAN>Could a geoprocessing tool be added that would perform that workflow out of the box? Or provide an option to do that as part of the export GP tool?</SPAN></P> Fri, 21 Apr 2023 04:28:10 GMT https://community.esri.com/t5/arcgis-pro-ideas/gp-tool-to-optimize-feature-order-for-improved-fc/idi-p/1281146 Bud 2023-04-21T04:28:10Z