Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020