Please suggest me optimization

Mihai 2015-11-03 09:59:36

Aaron Bertrand 2015-11-06 15:35:51
Hi Mihai, I can't see the whole query text because it is truncated in the plan XML. Is there any chance you could post the full query somewhere? The most expensive operators are sorts, and I'm trying to determine if those are being introduced intentionally or as a side effect of operators or join choices.