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
By Anamikha 1 asked Jun 08 at 09:35 AM
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
By Hugo Kornelis 271 answered Jun 09 at 08:44 AM