Archives of the TeradataForum

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

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

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