1. Is there a Candidate or Primary Index on table2.field1?
2. Is there a Regular Index on table1.field1+table1.field2?

I use character relations in my system, only because I have to.


If all else fails can you strip the table2.field1 into two separate fields? After all it sounds like you have two kinds of embedded meanings in a single field; normalization.