Archives of the TeradataForum

Message Posted: Wed, 27 Aug 2003 @ 20:09:45 GMT

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

I did a NCR contract where they made me make all the CHAR columns VARCHAR. I don't know if that was a standard but they paid my check and I did it.

Some would say that VARCHAR is better because even though COMPRESSION doesn't use a lot of CPU it still needs to use a little to convert back.

It comes down to cardinality when your making your choice. Are there enough unique values to warrent multivalue compression? If so then do it... If not then VARCHAR.

Save some space... Make a DBA happy... :)

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