topic Re: Recreate All Spatial Indexes at once? in Geodatabase Questions

Recreate All Spatial Indexes at once?

MattStull — Fri, 20 Jul 2018 18:22:09 GMT

I just upgraded by Enterprise Geodatabases from SQL Server 2005 to SQL Server 2014 and now I am getting the "Failed to compress the database. Underlying DBMS error [dbo.DEFAULT]" error message. From looking at other people's questions, it looks like I need to recreate the spatial indexes on all my feature classes. My question is:

Is there a tool or script that will recreate all of the feature classes in my geodatabase at once? So I don't have to do it one at a time?

Re: Recreate All Spatial Indexes at once?

JoeBorgione — Sun, 12 Dec 2021 10:04:20 GMT

Conceptually you can use the RebuildIndexes_management() in a loop. Something like this: (untested!)

import arcpy
arcpy.env.workspace = r'X:\use\path\of\connection\file

fcList = arcpy.ListFeatureClasses()
for fc in fcList:
    arcpy.RebuildIndexes_management(fc)‍‍‍‍‍‍

Re: Recreate All Spatial Indexes at once?

Asrujit_SenGupta — Sat, 21 Jul 2018 09:14:02 GMT

Rebuild Indexes—Help | ArcGIS Desktop

The tool can be used directly. Just select the SDE Connection file..

Re: Recreate All Spatial Indexes at once?

MattStull — Mon, 23 Jul 2018 14:56:57 GMT

Thank you for the help Asrujit!

Matt