This is a known issue. When the field being queried against belongs to a .dbf table that is joined to the layer, performance speed is reduced.
Get help from ArcGIS experts
Download the Esri Support App
Search for related information
Find training related to this topic
Explore ideas and give feedback