Archives of the TeradataForum
Message Posted: Tue, 09 Jun 2015 @ 10:00:57 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|