How to lower CPU time?
2013-11-05 17:03:20
Aaron Bertrand 2013-11-05 17:08:33
On quick glance, I see three distinct sorts in the plan. Are you sure you really need the outer DISTINCT on the actual query? I also see that the estimates are a bit off. Are your statistics up to date?