Archives of the TeradataForum

Message Posted: Thu, 17 May 2001 @ 06:58:25 GMT

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

Hi Mike,

This is expected behaviour: any UNIQUE or PK constraint is implemented as a unique index, UPI if there's no PI, USI if there's a PI

Submitting the statement using QueryMan 5.1.1 works without any errors....

If the PK is implemented as USI, you can't load that table using MultiLoad, you have to drop and recreate that USI.

Do you really have to implement that PK?

Another one, create that table as a multiset, this will speed up the inserts during MultiLoad, because there will be no Duplicate row checks. Depending on the maximum number of records per PI value this may be _much_ faster.

hth

Dieter

Dieter N�th
Teradata Certified Master
TBuS
Augsburg, Germany

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