Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 23 Jan 2001 @ 18:00:11 GMT


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


Subj:   Re: IDs datatypes for schema design
 
From:   Frank Martinez

Remember, that on a join where the primary indices are identical (or for that matter, if an index is used, period) that Teradata indexes are hashed. The data values were hashed when the data was put into the database, so there IS NO PENALTY when doing the join. Size doesn't make a difference IF THE INDEX IS USED. I don't know if hashing takes longer on Varchars, but I don't think that's the question.

--------------------------------------------

I accept that comparing longer datatypes takes longer than shorter ones (linear increase?)?

Frank C. Martinez IV



     
  <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