Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Ways to improve record deletion speed RE: Ways to improve record deletion speed

  • October 13, 2015 at 12:02 pm

    #1833051

    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?