I am deleting large amounts of data from a database table and i want it to be as quick as possible
I would like to try the following
Use MyDatabase
set transaction isolation level read uncommitted
Go
Delete from temptable where mark =2023
PRINT 'Number of rows deleted is ' + CAST(@@ROWCOUNT as char(3));
But i am not sure , is “read uncommitted” the best to set it at when deleting large amounts of data ?
Will this have an impact on users if they are trying to write to the database ?
Or is there a different isolation level to set it at ?
New contributor
Stacey is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.