Bug
ArcGIS Pro is stuck when joining the feature class from a file geodatabase to a table with a million records when the index on the join field on the table side exists, and the index is missing on the same field on the feature class side.
| Bug ID Number | BUG-000156768 |
|---|---|
| Submitted | March 20, 2023 |
| Last Modified | February 5, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.9.3 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Version Fixed | 3.5 |
| Status | Will Not Be Addressed |
Additional Information
The provided workaround is the correct workflow. We already show a performance warning when trying to join unindexed fields. We considered showing a separate warning message or auto-indexing in these cases, but there will also be performance problems with these solutions. The recommendation from the development team is to use the workaround provided.Workaround
There are 3 options on how to avoid this problem:
- Create an index on the joined feature class field before the join is added.
- Drop the index from the table field before the join is added.
- Keep the 'Index Join Field' checked when a join is being added.
Steps to Reproduce
Bug ID: BUG-000156768
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App