Spatial Indexes and Load Only IO Mode

Discussion created by nheick on Apr 27, 2012
Latest reply on May 6, 2012 by nheick
Good Afternoon,

Does anyone know if there is a difference between using the sdelayer -o load_only_io command versus the arcpy.management.RemoveSpatialIndex() function.  I would like to know if there is anything else going on in the background with load_only_io mode.  We are running several Spatial ETL tools and I want to improve performance during the loading of the data, but don't want the spatial indexes to get rebuilt at the end of any of the Spatial ETL tools.  I am confident the sdelayer command would work, but if the arcpy function is identical, it is much simpler to write a script tool that only uses the arcpy module versus the subprocess module.  I am not sure what can trigger the spatial indexes to be rebuilt.  I want to control when that happens.