Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Primary Key's vs indexes
From:   Dieter Nöth

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

  Also, under QueryManager, it rejects the DDL syntax with:  

  3516: More than one primary index or primary key specified !!!  

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

  Also (2), is a uniqueness constraint in effect (eg in MultiLoad UV rejections) from the PRIMARY KEY syntax (V2R3)?  

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.



Dieter Nöth
Teradata Certified Master
Augsburg, Germany

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016