how can i tune this join, its taking too long (around 1hour)

iamformydream 2016-05-19 16:13:45

In the temp table all the fields(3 fields) are indexed.

SQLkiwi 2016-05-20 17:10:46
I can't tell from an estimates-only anonymized plan with the query text truncated, sorry. Upload an actual plan, non-anonymized if possible.