Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Jun 2015 @ 10:00:57 GMT


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


Subj:   Write Lock - Partition level
 
From:   Sridhar K

Dear Forum,

Need your thoughts on below problem.

Is there any possibility to run parallel update on same table but on different partitions?

I know there is no partition level lock in Teradata, it will be only at Row Hash level or Table level.

Row Hash locks will upgrade to Table level write lock when there are multiple row hashes or sub queries in where condition though ?PI? or USI column is included.

So I just wanted to know if there is any other means to achieve parallel update?

Thanks in advance.


Thanks,

Sridhar K



     
  <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