How to lower CPU time?

ob123 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?