Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Jan 2001 @ 15:29:31 GMT


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


Subj:   IDs datatypes for schema design
 
From:   Leszek Kosinski

Dear Teradata Experts,

I have been working with Teradata v2r3 warehouse schema, developing a MicroStrategy 7 based reporting solution. I have recently found out that certain IDs/primary keys used in join operations between lookup and fact tables have been previously built on varchar or char datatypes. From performance perspective it should be beneficial to use numeric(integer - 8 bit) IDs datatypes for most of database products. The client has got a recomendation from NCR to use varchars. Have you heard of any special recommendations for Teradata for using particular datatypes for IDs/primary keys in the warehouse schemas. I would like to doublecheck whether datatype conversion process to numeric IDs would be a performance gain.


Thanks for any suggestions,

Leszek



     
  <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: 15 Jun 2023