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