Add Attribute Index (Data Management)

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

Summary

Adds an attribute index to an existing table, feature class, shapefile, or attributed relationship class.

Attribute indexes are used by ArcGIS to quickly locate records that match an attribute query.

Usage

  • Shapefiles and file geodatabase do not support multiple indexes, so additional fields will become part of a composite index (that is, an index created on multiple fields in a table).

  • Geodatabases have a new index added for each unique index name. If an index name already exists, it must be dropped before it can be updated.

  • For enterprise geodatabase data that is not registered as versioned, you can add both unique or non-unique indexes on GlobalID fields.

  • Unique and ascending indexes are not supported for shapefiles or file geodatabases. These parameters are ignored when the tool is executed on a shapefile or file geodatabase data.

Parameters

LabelExplanationData Type
Input Table

The table containing the fields to be indexed.

Mosaic Layer; Raster Layer; Table View
Fields to Index

The list of fields that will participate in the index. Any number of fields can be specified.

Field
Index Name
(Optional)

The name of the new index. An index name is necessary when adding an index to geodatabase feature classes and tables. For other types of input, the name is ignored.

String
Unique
(Optional)

Specifies whether the values in the index are unique.

  • Unchecked—All values in the index are not unique. This is the default.
  • Checked—All values in the index are unique.

Boolean
Ascending
(Optional)

Specifies whether values are indexed in ascending order.

  • Unchecked—Values are not indexed in ascending order. This is the default.
  • Checked—Values are indexed in ascending order.

Boolean

Derived Output

LabelExplanationData Type
Updated Input Table

The updated input table.

Table View; Raster Layer; Mosaic Layer

Environments

Licensing information

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

Related topics