The query is using very heavy CPU. any suggestions please

sqlmega 2015-10-08 18:37:57

Aaron Bertrand 2015-10-08 19:07:43
We don't have a lot to work with here. We can see that it's a big, complex plan, but it's a pre-execution estimated plan (so missing a lot of important runtime information) and it's been anonymized using an older version of Plan Explorer (which simply stripped out the entire statement). Can you please provide an actual plan generated from within the latest version of Plan Explorer?