Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 May 2004 @ 19:15:41 GMT


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


Subj:   Are Numeric Keys and Indices more efficient?
 
From:   Harvat, Joe

I recently started working as a consultant for a client with a large, Teradata data warehouse. It would appear most of the tables I've seen so far are defined with unique keys on columns that are character data type. Other relational database environments in which I've worked usually specified key columns that were integer or long integer data types. I was always told that these were more efficient (i.e. faster) than character fields. Is this still (or was it ever) true? If it does make a difference, has anyone seen any reliable statistics for how big of a difference it makes?


Thanks for your insights.

Joe Harvat
Professional Data Resources, Inc.
Cincinnati, Ohio



     
  <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