Archives of the TeradataForum

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

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

<-- 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>>