Archives of the TeradataForum

Message Posted: Fri, 09 Mar 2007 @ 20:11:48 GMT

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

I don't know whether this is true of past releases (it seems like this may have changed over time), but on v2r6, the collect stats command only takes an access lock on the target table, which is compatible with a write lock.

So, you should not have any lock contention on your target table.

Barry Hull
Orange Diamond Consulting, LLC

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