update times seem to be very slow based on what is being updated

Plan.pesession (104.6 kB)
avatar image By Fanz 0 asked Nov 29, 2017 at 09:18 PM
more ▼
(comments are locked)
avatar image Matak Nov 29, 2017 at 11:16 PM

Have you tried fixing the key lookup and updating your stats with fullscan ?

10|10000 characters needed characters left

1 answer: sort voted first

The plan you posted shows an execution time of 3 milliseconds. Not sure why you consider that slow?

Only a single row gets selected. For a single row, the plan looks as good as it can be. However, because you posted an anonymized plan, we can not see how complex and possible time-consuming the computations in the various Compute Scalar operators are (the formula used for the computation is removed as part of the anonymization). If these invoke a scalar user-defined function that needs to do a lot of work, then that UDF is where you need to focus your tuning efforts.

Although frankly, I would in most cases be happy with a 3ms execution time and not bother optimizeing it further. :)

avatar image By Hugo Kornelis 271 answered Nov 30, 2017 at 02:15 PM
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.

We are Moving!


Follow this question



asked: Nov 29, 2017 at 09:18 PM

Seen: 32 times

Last Updated: Nov 30, 2017 at 02:15 PM