One of the join fields in your layer does not have an attribute index. Using join fields with an index results in better drawing and query performance.
Check the drawing performance for your layer or basemap layer in ArcMap. If you are publishing, check the drawing performance for your service in the Preview window.
- If you see a need to make changes, add an attribute index to the join field in your dataset.
- Learn more about joining and relating tables
The potential issue of using joins that have not been indexed revolves around two technical aspects in the software: attribute indexes and attribute joins.
Attribute indexes can speed up attribute queries on feature classes and tables and will directly affect drawing performance. For most types of queries, it is faster to look up a record on an indexed field than it is to search through the entire table. Generally, you can improve overall performance using attribute indexes on key fields in your datasets.
Attribute joins append the fields of one table to those of another through a field that is common in both tables. A join is usually used to attach more attributes to the attribute table of a layer. Using indexed fields for your join will significantly improve performance in most situations.