Archives of the TeradataForum
Message Posted: Fri, 26 Aug 2005 @ 16:46:15 GMT
<-- 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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|