ScottPletcher (10/13/2015)
For absolute max speed, you should also cluster the temp table on ID
Thanks Scott. I do in fact do that, declaring the ID as a PRIMARY KEY.
CREATE CLUSTERED INDEX TEMP__CL ON #TEMP ( ID ) WITH ( FILLFACTOR = 100 )
I think it will benefit from being declared as a UNIQUE index?