ArcGIS 9.3.1, ArcInfo. I have some small file geodatabase and SDE featureclasses (few thousand records each, 50 columns) that I am doing attribute joins on. After the joins, drawing of the map is slowed down from sub-second to several seconds each time, sometimes more. Add in some definition queries that reference fields from the join and it's time to go get a cup of coffee while redrawing. Any ideas on why this happens? Anyone else ever experienced this?
Originally a comment: