Reduction in table size


Reduction in table size

Hi all,

I need to zip my table data at teradata.
Some one told me that there is one feature in teradata through which we can zip our data by analysing our data demographics.
So that rather than scarrating data in multiple AMP it should resides in 2 or 3 AMP.
Any idea.


Re: Reduction in table size

Are u by any chance referring to multi valued compression? It does not limit to the data to 2 or 3 amps but it certainly reduces the space occupied by the table especially when you have repetitive values in the column that is compressed.
If you are referring to multi valued compression, you have enough information on this in the manuals. Refer the same or try and google it!

Hope this helps!