Archives of the TeradataForum
Message Posted: Thu, 17 May 2001 @ 06:58:25 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|