Need help in optimizing the plan

Anamikha 2018-06-08 09:35:01

Hi SqlSkills Team,

I would need your valuable suggesstion to optimize this query plan.

I have done index rebuild for all the indexes in the table

and update statistics fo all the tables
Exec sp_msforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN;'

Kindly give suggestions to reduce the execution time from 13 seconds to few milli seconds
Also, how to fix the tempdb spill warning

Hugo Kornelis 2018-06-09 08:44:32