multi value compression

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

multi value compression

Rate Topic

Display Mode

Topic Options

Author

Message

gander_ss

Posted 5/5/2008 2:04:13 AM

Forum Member

Group: Forum Members
Last Login: 7/17/2008 3:13:01 AM
Posts: 30, Visits: 67

Hi all,

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

Regards,
gander_ss

Post #11357

Posted 5/5/2008 9:28:43 AM

Forum Member

Group: Forum Members
Last Login: 7/16/2008 1:53:21 PM
Posts: 48, Visits: 100

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

-SN

Post #11359

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:13am