We have a feature class and a joined table by attribute.
Recently, we change the source of the joined table.
In the past, it was located in a geodatabase, now - in a file geodatabase.
The problem is a poor performance on Select by attribute by the field from the joined table.
Both joined fields are indexed. Searching field (Select by attribute) is indexed.
The only difference is that in the past the joined field in joined table was a primary key, now not (just indexed).
What could be a reason for the poor performance?