thomashohner (8/28/2014)
For the most part its being updated from the same 4 or 5 tables. On each Update. With different criteria on each one.FROM #RESULTS r
INNER JOIN table1 t1 ON r.ID =t1id
I would consider a Primary Key on the column at least, assuming that it is unique in the temp table, more for ensuring results, but there may be performance benefits as well.
I'd be curious to see the code, because I'm sure there's stuff going on that could be combined or cut out.