Using the Rebuild Indexes tool to rebuild indexes on geodatabase system tables

This topic applies to ArcGIS for Desktop Standard and ArcGIS for Desktop Advanced only.

Database indexes are used to quickly identify rows that meet a query's predicate filter. Most of the geodatabase system tables have indexes, but the tables that tend to have the greatest amount of change in a versioned enterprise geodatabase and, therefore, require the indexes to be rebuilt most often are the states, state_lineages, and mv_tables_modified system tables. As the geodatabase administrator, you can rebuild the indexes on these tables in geodatabases in IBM DB2, Microsoft SQL Server, Oracle, or PostgreSQL databases using the Rebuild Indexes geoprocessing tool.

In a heavily edited versioned geodatabase, you might update indexes on the states, state_lineages, and mv_tables_modified tables nightly. To do that, create a stand-alone Python script that calls the Rebuild Indexes tool and schedule it to run using Windows Scheduled Tasks or a cron job. See Rebuilding indexes on geodatabase system tables using a Python script.

Tip:

The Rebuild Indexes tool can also be used by data owners to rebuild attribute and spatial indexes on their data. See Rebuilding dataset indexes for more information.

To rebuild indexes on the states, state_lineages, and mv_tables_modified geodatabase system tables using the Rebuild Indexes tool, do the following:

Steps:

1. Start ArcMap or ArcCatalog and connect to the ArcSDE geodatabase as the geodatabase administrator.
2. Open the Rebuild Indexes geoprocessing tool.

   This tool can be found in the Geodatabase Administration toolset of the Data Management toolbox.

3. Use the connection you created in step 1 as the input workspace.
4. Check the System tables check box.
5. Click OK to run the tool.