Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 11:17:36 GMT


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


Subj:   Index Mechanism?
 
From:   Sujay Shirish Paranjpe

I have a question related to Index.

     Case 1:
     Create Table Tab1 (
     Col1 INT,
     Col2 INT
     ) UNIQUE PRIMARY INDEX (Col1)


     Case 2:
     Create Table Tab2 (
     Col1 INT,
     Col2 INT
     ) UNIQUE PRIMARY INDEX (Col1, Col2)

In the first case value of Col1 will be used while inserting and pulling the data from AMPs. But how exactly the Indexing will work in the second case? Is it the case that the combination of Col1 and Col2 will be HASHED and then that hash value is used to insert or pull data from database?

Please help.


Sujay Paranjpe



     
  <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