Table Hints - nolock - Table Locks

Posts   
 
    
Posts: 94
Joined: 23-Aug-2006
# Posted on: 05-Dec-2006 22:43:32   

A while back, it must have been over a years ago, we had a discussion on the forum regarding the need for a nolock table hint. (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=2482)

At the time Otis implemented a global setting that would cause the DQE to modify its output by adding the nolock hint to select statements.

What's the current state of affairs for this functionality in 2.0? Is there still a reason for it? Is it still used? Has there been a change in the usage of llblgen that may circumvent the need for it? (i.e. the way certain steps are wrapped in transactions). If you read the old thread, there were some definite reasons why people needed it.

Thanks, Thomas