Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2012 @ 17:34:03 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Table Locking
 
From:   David Clough

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 ?


Regards

David Clough
BI Competency Centre



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016