Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Dec 2003 @ 10:34:47 GMT


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


Subj:   Primary Index
 
From:   Dennis Havez

Hie All,

Is someone knows what's happen if I compare a table with 15 attributs which will be Primary Index and Primary Key of the table (Ex1) and on the other hand a Table with 15 attributs with just 2 or 3 PI (which will be used for join other table) and a constraint Primary Key on the attributs (Ex2) ?

Ex1.

CREATE TABLE test
(
      id1   INTEGER,
      id2   INTEGER,
      id3   INTEGER,
...
      id13  INTEGER,
      id14  INTEGER,
      id15  INTEGER
)
UNIQUE PRIMARY INDEX (id1, id2, id3 ..., id13, id14, id15)

Ex2.

CREATE TABLE test
(
      id1   INTEGER,
      id2   INTEGER,
      id3   INTEGER,
...
      id13  INTEGER,
      id14  INTEGER,
      id15  INTEGER,
      PRIMARY KEY(id1, id2, id3 ..., id13, id14, id15)
)
UNIQUE PRIMARY INDEX (id1, id2, id3)

Do you know what is the best solution in the case where the table contient more 100 millions rows ?

That's a lot,

Denis



     
  <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: 15 Jun 2023