Archives of the TeradataForum

Message Posted: Thu, 04 May 2006 @ 22:18:41 GMT

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

It is always recommended to use row level locking if possible. This helps in scalability. If you can code your SQL to use row level locking (single AMP and Group AMP) it helps in using only required resources. In these situations, we may allocate resources which may not be needed if it is an All AMP operation.

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