Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.

hth

Dieter

Dieter Nöth
Teradata Certified Master
TBuS
Augsburg, Germany



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