topic Re: Arcpy - Rebuild indexes in file geodatabase in Python Questions

Arcpy - Rebuild indexes in file geodatabase

MaximeDemers — Sat, 11 Dec 2021 17:22:43 GMT

I am trying to automatize the rebuild of file geodatabase indexes using arcpy v10.6, but I encounter an ERROR 000837 The workspace is not the correct workspace type.

Why? Does arcpy.RebuildIndexes_management() works only with Enterprise geodatabases? Then, how to rebuild indexes in file geodatabases?

Thank you

import arcpy, os

workspace = "C:/tmp/myDatabase.gdb"
fc = "MyFeatureClass"
arcpy.Exists(workspace)
>>>True
arcpy.Exists(os.path.join(workspace, fc))
>>>True

arcpy.RebuildIndexes_management(workspace, "NO_SYSTEM", [fc], "ALL")
>>>ERROR 000837 The workspace is not the correct workspace type.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcpy - Rebuild indexes in file geodatabase

JoeBorgione — Wed, 04 Dec 2019 18:04:43 GMT

Can you run the tool manually on the fgdb?

Re: Arcpy - Rebuild indexes in file geodatabase

MaximeDemers — Wed, 04 Dec 2019 18:11:32 GMT

It seems that you can only use that tool with Enterprise geodatabase because the first parameter in the toolbox accepts only .sde files...

Re: Arcpy - Rebuild indexes in file geodatabase

JoeBorgione — Wed, 04 Dec 2019 18:12:44 GMT

That's what it looks like to me as well...

Rebuild dataset indexes using the Rebuild Indexes tool—ArcGIS Help | ArcGIS Desktop

Re: Arcpy - Rebuild indexes in file geodatabase

MaximeDemers — Wed, 04 Dec 2019 18:14:55 GMT

Then, the solution would be to drop and recreate the indexes?

Re: Arcpy - Rebuild indexes in file geodatabase

JoeBorgione — Wed, 04 Dec 2019 18:31:16 GMT

I just have to ask: What's the end game? Why do you need your indexes rebuilt?

Re: Arcpy - Rebuild indexes in file geodatabase

MaximeDemers — Wed, 04 Dec 2019 19:36:46 GMT

Because the data is updated regularly in this database

Re: Arcpy - Rebuild indexes in file geodatabase

KimOllivier — Thu, 12 Dec 2019 22:21:55 GMT

You just use the ArcTool arcpy.management.AddSpatialIndex(). The help explains it will rebuild an existing index. Since the indexing is simpler you don't need to specify the spatial grid sizes. I have done this after loading data into a large featureclass and it makes a huge difference to drawing speed and processing.

If processes appear to hang it is always worthwhile to interrupt the process, rebuild the indexes (including attribute indexes) and restart the process. Never be happy with any tool that takes longer than a cup of coffee. Find a better way.

Note that you need to ensure that your features are small and contiguous relative to the full extent. If you have a large 'Mozilla' feature such as an enclosing coastline or large area punctuated with 'holes' representing forest you will defeat the spatial indexing. This is what the DICE tool is for, to split up unreasonably large polygons.

The same applies to polylines. A single line representing a national highway included with short local roads will make all processes that use an index be very slow. Also do not be tempted to dissolve by a single attribute to 'normalize' the attribute table where one zone is represented by thousands of multi-part polygons.

Running processing across a network is likely to be very slow. Process locally, which means: extract, process, replace.

Re: Arcpy - Rebuild indexes in file geodatabase

MaximeDemers — Fri, 13 Dec 2019 13:24:32 GMT

Thank you for the great explanations. It's very useful!

I have another question about indexes, maybe you could answer it...

When you copy a file geodatabase using arcpy.CopyManagement() or when publishing a service to ArcGIS Server Enterprise and data are copied, does the indexes are recreated or just copied as is?

Re: Arcpy - Rebuild indexes in file geodatabase

MarkVolz1 — Sun, 20 Sep 2020 23:29:48 GMT

Hi,

I know this is a bit late but when using file gdb's you can only add and delete an attribute index, not rebuild it (unless you use the above cheat with the spatial index ). The arcpy functions to do these operations can be found here: An overview of the Indexes toolset—ArcMap | Documentation