topic Create partition by location in Data Management Questions https://community.esri.com/t5/data-management-questions/create-partition-by-location/m-p/123654#M7124 <HTML><HEAD></HEAD><BODY><P>We have a very large point layer in geodatabase in Oracle.</P><P>We would like to use partitions to make it work quicker.</P><P>The only operation we do on this layer is to pan/zoom on it so we would like to build the partition on the location.</P><P>The only thing I found in the docs is to make the spatial index (<SPAN style="font-size: 11.0pt;"><SPAN><A href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/spatial-indexes-and-stgeometry.htm">http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/spatial-indexes-and-stgeometry.htm</A>&nbsp;</SPAN></SPAN>)</P><P>We would like to do it on the real features.</P><P>&nbsp;</P><P>What is the best way to do it?</P><P>&nbsp;</P><P>Thanks</P></BODY></HTML> Tue, 17 Jan 2017 09:03:45 GMT ModyBuchbinder 2017-01-17T09:03:45Z Create partition by location https://community.esri.com/t5/data-management-questions/create-partition-by-location/m-p/123654#M7124 <HTML><HEAD></HEAD><BODY><P>We have a very large point layer in geodatabase in Oracle.</P><P>We would like to use partitions to make it work quicker.</P><P>The only operation we do on this layer is to pan/zoom on it so we would like to build the partition on the location.</P><P>The only thing I found in the docs is to make the spatial index (<SPAN style="font-size: 11.0pt;"><SPAN><A href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/spatial-indexes-and-stgeometry.htm">http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/spatial-indexes-and-stgeometry.htm</A>&nbsp;</SPAN></SPAN>)</P><P>We would like to do it on the real features.</P><P>&nbsp;</P><P>What is the best way to do it?</P><P>&nbsp;</P><P>Thanks</P></BODY></HTML> Tue, 17 Jan 2017 09:03:45 GMT https://community.esri.com/t5/data-management-questions/create-partition-by-location/m-p/123654#M7124 ModyBuchbinder 2017-01-17T09:03:45Z