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

Description

Performance when using a join may be greatly enhanced if the join field is indexed.

Solution

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