The contruct '% %' makes any index you have on Table1 field1 unusable. It is not SARGABLE (look that up on Google or another search index). An index on Table2 Filed2 might help.