Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Aug 2005 @ 16:46:15 GMT


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


Subj:   Different Data Types and Performance
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, August 26, 2005 12:42 -->

What does Teradata have to do, under the covers, when comparing or joining on two different data types?

ex: CHAR to VARCHAR, INTEGER to DECIMAL, CHAR(4) to CHAR(5), byteint to integer, date(yyyy-mm-dd) to date(yy/mm/dd)

1) DO these examples cause performance decreases, extra work like "translations"?

2) Does it do trims, etc.....?

3) What is the performance benefit for having all of the same column names the same data types throughout the Data Warehouse?



     
  <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