Effect of NOLOCK hint in SELECT statements

by

I guess the real question is:

If I don’t care about dirty reads, will adding the with (NOLOCK) hint to a SELECT statement affect the performance of:

  1. the current SELECT statement
  2. other transactions against the given table

Example:

Select * 
from aTable with (NOLOCK)

5 Answers
5

Leave a Comment