Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 15:19:56 GMT

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

It is probably a NUPI dup (non unique primary index problem). This occurs because of duplicate row checking.

Make sure the primary index choice is unique or nearly unique.

You can also make the table multiset to avoid duplicate row checking. However, you know have to worry about duplicate rows. Also the table will be skewed so performance will suffer.

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA

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