InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 12:45:17 GMT20http://www.teradata.com/teradataforum/Topic11357-9-1.aspxhi,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 designatedfor multivalued compression.thxMon, 05 May 2008 09:28:43 GMTSNhttp://www.teradata.com/teradataforum/Topic11357-9-1.aspxHi all,Is there any one who can tell that multi value compression can be implement in existing table ???Regards,gander_ssMon, 05 May 2008 02:04:13 GMTgander_ss