Hi, I have a query that joins an nvarchar field from one table to a varchar field from another. The execution plan indicates that this one join will consume 92% of the resources for the entire query. When I comment out the join, it runs in 51 seconds, but with it, 8.5 minutes. I don't have admin access to the source db and cannot change the data types of the fields in the tables I am querying. What is the best approach to improve performance for the query?
Thanks in advance!