Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.


Sridhar K

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