Archives of the TeradataForum

Message Posted: Tue, 28 Feb 2006 @ 18:41:15 GMT

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

Suresh,

As Victor said .. It makes sense if data_soruce_cd is of same data type on both tables ... In any RDBMS using functions on JOIN clause will degrade performance bcos of unnecessary data type conversions .

I have few questions for you ...I don't know much abt your application or data but

1) Why the source_cd will have NULL values ?

2) Have you collected stats on DATA_SOURCE_CD on both tables ?

Thanks,

Srini

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