how to improve this select statemant

tmpC91.pesession (11.7 kB)
avatar image By TheGunners 1 asked Sep 25 at 07:58 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

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

avatar image By PARAG 1 answered Sep 26 at 11:12 AM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x631
x445
x1

asked: Sep 25 at 07:58 PM

Seen: 33 times

Last Updated: Sep 26 at 11:12 AM