Need help in optimizing the plan
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