Archives of the TeradataForum

Message Posted: Thu, 19 Dec 2002 @ 16:56:12 GMT

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

Is the altered column part of the primary index? If it is you are redistributing the entire table because the hashing has changed. The char data type will take 15 bytes per row instead of 8 bytes for decimal, it might go to spool for conversion. I would recommend explicitly left padding the converted char column with zero's. I had some issues in the past with int <-> char, but I don't remember the details (maybe trailing spaces becoming zeros??).

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