AnsweredAssumed Answered

Poor performance join on database VS file geodatabase

Question asked by mik1971 on Jul 17, 2017

Hi,

 

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?

Outcomes