No Lock

What is 'no lock' term in SQL, like "select * from table a (no lock)". What is its purpose?

Questions by nasiriq

Showing Answers 1 - 2 of 2 Answers

sidhuonline

  • Jun 30th, 2009
 

It is useful to improve the performance in executing the query. However there is a disadvantage in using it. The disadvantage is that one may not be sure that they are getting the data which is currently being updated in the Table ie Without lock protection, you cannot be guaranteed that the data isn’t changing during the time that the query is running.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions