Available with Standard or Advanced license.
An index can exist on a single field or a set of fields. As datasets in a geodatabase are edited over time, the indexes may need to be rebuilt for optimal performance. Rebuilding indexes on these datasets can improve index efficiency.
You can use the Rebuild Indexes geoprocessing tool in ArcGIS to rebuild indexes on datasets in an enterprise, workgroup, or desktop geodatabase. The data owner can use this tool to rebuild both attribute and spatial indexes for one or many different datasets at once.
If the table or feature class is registered as versioned, the data owner can rebuild indexes on the base and delta tables or just the delta tables. You might rebuild indexes on just the delta tables if you have loaded a large amount of data into your table or feature class or deleted or edited a large amount, and the edits are going to remain in the delta tables (not be compressed) for several days.
When you rebuild indexes for a feature dataset, indexes are rebuilt on all the feature classes and other classes in that feature dataset. If the feature dataset contains a topology, the topology tables are also updated.
The tool also has an option to rebuild indexes for the geodatabase system tables, which can be used only by the geodatabase administrator.
To rebuild indexes on your datasets using the Rebuild Indexes tool, do the following:
- Start ArcMap or ArcCatalog and connect to the enterprise geodatabase that contains the data you own for which you want to rebuild indexes.
- Open the Rebuild Indexes geoprocessing tool.
This tool can be found in the Geodatabase Administration toolset of the Data Management toolbox.
- Use the connection you created in step 1 as the Input Database Connection.
- Check the boxes next to the datasets for which you want to rebuild indexes.
- If you only want to rebuild indexes on the delta tables of the chosen dataset, click outside the datasets list and check Rebuild Delta Tables Only.
- Click OK to run the tool.