Compress a table???

Database
N/A

Compress a table???

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

Thanks in adv,
Sparan
3 REPLIES

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

N/A

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
N/A

Re: Compress a table???

Thanks