Archives of the TeradataForum

Message Posted: Thu, 11 Oct 2007 @ 19:54:57 GMT

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

There's even another benefit to LOCKING ROW FOR ACCESS besides less typing and not having to remember to list every table. LOCKING at the table level (even FOR ACCESS) is an ALL-AMPs operation. That's wasted effort if your query is single-AMP or few-AMP.

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