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.
11