how to improve this select statemant

TheGunners 2017-09-25 19:58:45

PARAG 2017-09-26 11:12:53
Can you try to use option (maxdop 1) at the end of the query and then check the performance.

The maxdop in the select operator is 24 and that looks a bit odd