Need help in optimizing the plan
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
2018-06-09 08:44:32
This appears to be a duplicate. Please ignore and look at https://answers.sqlperformance.com/questions/5119/how-to-fix-tempdb-spill-warning-and-reduce-the-lon.html instead