EGMP2201 practice question 14 of 15

A GIS analyst creates a join relationship between a large dataset and a nonspatial table to calculate an attribute field. Upon building the join, the analyst receives an error message stating that the join field in the join table is not indexed. Which tool should the analyst run?

Full set: 65 questions
Answer options
A: Add Spatial Index
B: Add Attribute Index Correct answer
C: Rebuild Indexes
Correct Answer:
B. Add Attribute Index
Explanation

The error message "the join field... is not indexed" explicitly identifies the problem. An attribute index is a data structure that dramatically improves the speed of queries and joins based on attribute fields. When joining large tables, ArcGIS Pro requires or strongly recommends an index on the join field of the join table to perform the operation efficiently. The Add Attribute Index tool is the correct geoprocessing tool to create this necessary index on the specified attribute column, thereby resolving the error and allowing the join to proceed.

Why Incorrect

A. Add Spatial Index: This tool creates an index on the geometry (shape) field of a feature class to speed up spatial queries, not queries based on attribute fields.
C. Rebuild Indexes: This tool is used to update or defragment existing indexes. The error message indicates that an index does not exist, so there is nothing to rebuild.

References

1. Esri ArcGIS Pro Documentation, "Add Attribute Index (Data Management)": "Adds an attribute index to an existing table, feature class, or attribute relationship class... Attribute indexes can speed up attribute queries on feature classes and tables." This document confirms the tool's purpose is to create an index on an attribute field to improve performance.

2. Esri ArcGIS Pro Documentation, "Joins and relates": Under the "Performance of joins and relates" section, the documentation states, "To improve performance when working with joined data, you can create an attribute index for the join fields." This directly supports using an attribute index to resolve performance issues and errors during a join.

3. Esri ArcGIS Pro Documentation, "Indexes in geodatabases": "An attribute index is an alternate path used by ArcGIS to retrieve a record from a table... When a field is indexed, queries to find a record with a particular attribute value... can use the index to avoid a full table scan." This explains the underlying mechanism and why an index is critical for large datasets.

4. Penn State University, GEOG 485: GIS Database Development, Lesson 5: Improving Database Performance: The courseware discusses indexing as a primary method for performance tuning. It states, "An index is a data structure that improves the speed of data retrieval on a database table... The classic example of a situation where an index is helpful is a join between two tables." This academic source validates the principle of indexing join fields.

Scroll to Top