Compress a table???

Database
Enthusiast

Compress a table???

could any one please tell me how to compress a Teradata table?

Thanks in adv,
Sparan
3 REPLIES
Enthusiast

Re: Compress a table???

Sparan,

I hope you cannot compress a table in Teradata, But,you can compress values for a column in a table.

The Syntax is as shown below.

Create table test
(
a char(5) compress 'Manual',
b integer);

By compressing certain values for a field, you can reduce the rowsize and therby the block size.Reading such rows becomes easier and less expensive.
You can find more on this in Physical implementation and design documents

Enthusiast

Re: Compress a table???

There are some restrictions.
You may want to go thru this white paper for more on this.

http://www.teradata.com/t/page/86995/index.html

Vinay
Enthusiast

Re: Compress a table???

Thanks