• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 758
  • Last Modified:

WITH NOLOCK

Could WITH NOLOCK slow down select statements?

I think I can notice a considerable difference in speed since I added WITH NOLOCK to some of the select statements.
0
Tacobell777
Asked:
Tacobell777
2 Solutions
 
SvenTech Lead Web-DevelopmentCommented:
We are using WITH NOLOCK on our servers but I never experienced a slow down when using it.
0
 
LowfatspreadCommented:
i suppose its possible, depends how many dirty rows are in the range of the select..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now