Archives of the TeradataForum

Message Posted: Mon, 23 May 2011 @ 22:28:57 GMT

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

Thanks for the reply. So I going to ask the problem I am trying to solve. I have field call STATE_CD char(02). The local state has about 1/2 of the values, but there are state from all across the country. I decided to compress all 50 states. I was told this is a bad idea because of the presence bit overhead.

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