I am trying to match a set of records with FirstName and LastName. However, the not all of the FirstName and LastNames are identifcal. So I am trying match by using the LIKE expression to match by similarties.
However, the problem is that when I added the LIKE in the LEFT JOIN of the dervied columns (subquery)...The query ran forever and never finished...my query without the LIKE expression finishes running in 8 minutes. But when I added the LIKE expression in
the LEFT JOIN it ran for over 17 hours and never finished.
NOW IS THERE ANOTHER WAY OF DOING THE SAME THING WITHOUT SLOWING DOWN THE QUERY?