English

How To: Change the spatial index on a versioned feature class in ArcCatalog

Summary

ArcCatalog modifies spatial indexes by deleting them, then re-adding them in a two-step process. Versioned feature classes can only have their indexes modified by altering them.

Procedure

  1. Open the properties for the feature class in ArcCatalog.
  2. Click the Indexes tab, and click Delete under spatial index.
    Once there is data in a geodatabase table or feature class, to make queries faster, it may be necessary to create attribute indexes. Spatial indexes increase the selection speed of graphical queries on spatial features. An attribute index is an alternate path used by the DBMS to retrieve a record from a table. It is much faster to first look up the index and then go to the appropriate record than to start at the first record and search through the entire table.

    Attribute indexes can be created for single or multiple fields on the feature class and table property pages. Once an index is added, it can be deleted and re-add it at any point in the lifetime of the feature class or table.

    The same property page can be used to delete a spatial index and a spatial index can be added to the ArcSDE feature class.

    The spatial index can be modified for an ArcSDE feature class by deleting the index and recreating it. The features stored in an ArcSDE feature class cannot be accessed if it does not have a spatial index.

    [O-Image] [O] Indexes property page
  3. Click Apply. You will get the following error message: “Failed to delete spatial index. Attempting to make multiversioned table load-only, or vice-versa[].”
  4. Click Cancel to close the dialog box.
  5. Open the properties again.
  6. Click Add under Spatial index and type the new spatial index values. Click OK to dismiss the sub-dialog box.
  7. Click OK, or Apply, to build the new index.