multi value compression

Database
Enthusiast

multi value compression

Hi all,

Is there any one who can tell that multi value compression can be implement in existing table ???

Regards,
gander_ss

1 REPLY
SN
Enthusiast

Re: multi value compression

hi,

you can add a new column with multi valued compression to an existing table, but cannot modify an existing compressed column.
Instead, you can either create a new table with the column designated for multivalued compression and INSERT … SELECT data into it from the existing table or you can use CREATE TABLE … AS with the target column designated
for multivalued compression.

thx