Forum Discussion
Delete Statement slowness
Hello, We are running a delete statement on database every weekend where it deletes rows based on the 16 where conditions. It has to pass 16 where conditions before delete more than millions row....
takes time to delete more than a millions of data.
Delete the data batch wise, e.g. always 10K rows instead of all in one run.
DELETE TOP (10000)
FROM yourTable
WHERE ....