Home Forums SQL Server 2008 SQL Server 2008 - General DELETE FROM Table WHERE PKID = 0 -runs for over 5 min without completing RE: DELETE FROM Table WHERE PKID = 0 -runs for over 5 min without completing
Maxer
SSCrazy Eights
Points: 8964
More actions
July 25, 2013 at 10:19 am
#1635819
Well adding an index will take forever, just dropped them. Did the deletes then re-created.
Since this table will have deletes perhaps once per quarter, I think that's the way to go...