Archives of the TeradataForum

Message Posted: Mon, 28 Jul 2003 @ 12:14:56 GMT

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

The problem is not the Volatile table, but your choice of Primary Index on it. If you do not specify a primary index on the create table statement it will assign the first column as the NUPI (not always the best choice).

Specify a Primary Index statement and you should have no problems.

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