Archives of the TeradataForum

Message Posted: Fri, 05 Dec 2003 @ 20:10:09 GMT

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

I believe you can use 'alter table' to add single value compression if you did't have it yet. In addition to that, you might be able to change the compression value if the change does not affect the data. For example, if you have the compression value of 'A' and this value does not occur in the column at all, then you might be able to change the value to, say, 'B' using 'alter table'.

I did not try multivalue compression as yet but it looks like you cannot add or alter it using 'alter table'.

You can find the 'alter table' syntax in RDBMS Ref Vol. 4, Ch.1.

Having said that I want to add that I would go for the INSERT ... SELECT into a new table rather than use 'alter table' in these cases. Just to stay on the safe side and make sure that the data distribution is optimal.

Regards,

Victor

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