Rebuild Indexes (Data Management)

This ArcGIS 3.0 documentation has been archived and is no longer updated. Content and links may be outdated. See the latest documentation.

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.

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