Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 23 Jan 2001 @ 14:15:52 GMT


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


Subj:   Re: IDs datatypes for schema design
 
From:   John Dubery

Dave,

I have some follow up questions to your advice. I'm interested in how precise you have to be to avoid any overhead with varchars.

a) if join column datatypes are identical is it (essentially) the same cost for a join whatever that type is. I accept that comparing longer datatypes takes longer than shorter ones (linear increase?)?

b) Is there an overhead when joining varchar to char for the same (max.) length?

c) Is there an overhead when joining varchar to varchar for different max lengths?


Thanks,

John



     
  <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