000970: The join field <value> in the table <value> is not indexed. To improve performance, we recommend that an index be created.

Description

Attribute indexes can speed up joins and other attribute queries on feature classes and tables. An attribute index is an alternate path used by ArcGIS to retrieve a record from a table. For most types of attribute queries, it is faster to look up a record with an index than to start at the first record and search through the entire table.

Solution

Before adding the join, add an index on the join field in the table using the Add Attribute Index tool.