Add Attribute Index (Data Management Tools)
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 geodatabases do not support multiple indexes. Additional fields will become part of a composite index (that is, an index created on multiple fields in a table).
A new index is added for each unique index name in a geodatabase or database. If an index name already exists, it must be dropped before it can be updated.
In enterprise geodatabases and databases, you must be the owner of the table or feature class to add an index to it.
For enterprise geodatabase data that is not registered as versioned, you can add both unique or nonunique indexes to GlobalID fields.
Unique and ascending indexes are not supported for shapefiles or file geodatabases. These parameters are ignored when the tool is run on a shapefile or on file geodatabase data.
Parameters
| Label | Explanation | Data 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 be indexed. 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.
|
Boolean |
|
Ascending (Optional) |
Specifies whether values will be indexed in ascending order.
|
Boolean |
Derived output
| Label | Explanation | Data type |
|---|---|---|
|
Updated Input Table |
The updated input table. |
Table View; Raster Layer; Mosaic Layer |
Environments
Licensing information
- Basic: Yes
- Standard: Yes
- Advanced: Yes