Can you compress a column which is
already present in table using ALTER in Teradata?
No, We cannot use ALTER command to
compress the existing columns in the table.
A new table structure has to be created which
includes the Compression values and data should be inserted into Compress
column table.
Please note - ALTER can be used only to add
new columns with compression values to table.
No comments:
Post a Comment