Archives of the TeradataForum
Message Posted: Fri, 14 Sep 2012 @ 17:34:03 GMT
We've decided to allow some Users to maintain some relatively static data in Teradata Tables, via some Stored Procedures.
What hadn't occurred to me at the time, however, is whether those Updates and Inserts would initiateTable Locks or Row Locks. I somewhat assume the former ,now that I think about it.
Assuming Table level locks, is there any way of making them Row Level locking (in the same way that TPump would 'enjoy') or, since it won't be like an operational database type maintenance (ie. fast, fast, fast), does it not matter ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|