Archives of the TeradataForum
Message Posted: Wed, 17 Jan 2001 @ 15:29:31 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|