Rebuild Indexes (Data Management)

ArcGIS Pro 3.3 | | Help archive

Summary

Rebuild existing attribute or spatial indexes in enterprise geodatabases. Indexes can also be rebuilt on states and state_lineage geodatabase system tables and the delta tables of datasets that are registered to participate in traditional versioning. Out-of-date indexes can lead to poor query performance.

Usage

  • Data must be from a database or an enterprise geodatabase. This tool does not work with file geodatabases.
  • After data loading, deleting, updating, and compressing operations, it is important to rebuild indexes.
  • This tool rebuilds the attribute and spatial indexes of base tables, delta tables, and archive tables in versioned and archive-enabled geodatabases.
  • The Include System Tables parameter determines if indexes are rebuilt on the states and state lineages tables in the specified geodatabase. When the option is unselected, the indexes on these tables are not rebuilt. If the Include System Tables parameter is unchecked, at least one dataset needs to be selected in the Datasets to Rebuild Indexes For to run the tool.
  • The Datasets to Rebuild Indexes For parameter's Add Value button is used only in ModelBuilder. In ModelBuilder, where the preceding tool has not been run or its derived data does not exist, the Datasets to Rebuild Indexes For parameter may not be populated with values. The Add Value button allows you to add expected values so you can complete the dialog box and continue to build your model.
  • This tool is not supported with SAP HANA.

Parameters

LabelExplanationData Type
Input Database Connection

The connection (.sde file) to the database or geodatabase that contains the data for which you want to rebuild indexes.

Workspace
Include System Tables

Indicates whether indexes will be rebuilt on the states and state lineages tables.

You must connect as the geodatabase administrator for this option to be activated.

This option only applies to geodatabases. If you connect to a database, this option is disabled.

  • Unchecked—Indexes will not be rebuilt on the states and state lineages table. This is the default.
  • Checked—Indexes will be rebuilt on the states and state lineages tables.
Boolean
Datasets to Rebuild Indexes For
(Optional)

Names of the datasets that will have their indexes rebuilt. Only datasets that are owned by the connected user are displayed.

String
Rebuild Delta Tables Only
(Optional)

Indicates whether indexes will be rebuilt only on the delta tables of the selected datasets. This option will be unavailable if there are no datasets selected in the list of input datasets.

This option only applies to geodatabases. If you connect to a database, this option is disabled.

  • Checked—Indexes will only be rebuilt for the delta tables of the selected datasets. This option can be used for cases where the business tables for the selected datasets are not updated often and there are a high volume of edits in the delta tables. This is the default.
  • Unchecked—Indexes will be rebuilt on all indexes for the selected datasets. This includes spatial indexes as well as user-created attribute indexes and any geodatabase-maintained indexes for the dataset.
Boolean

Derived Output

LabelExplanationData Type
Updated Workspace

The updated workspace.

Workspace

Environments

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes

Related topics