Archives of the TeradataForum

Message Posted: Wed, 20 Mar 2002 @ 13:42:16 GMT

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

Is not only the table you altered is lock but

ALL REQUEST IN COMING TO THE TERDATA.

It's because a table lock is needed for some table of DBC.

Look in the EXPLAIN to figure out how Teradata do it.

Rudel Simard
R�gie de l'assurance-maladie du Qu�bec
DBA de l'environnement informationnel

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