Archives of the TeradataForum

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

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

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>>