Compression In Teradata

Database
Enthusiast

Compression In Teradata

How does Compression works in Teradata?Where in Teradata Compressed value information is stored and retrieved ?
Say For example :
If I have compressed a column value "Ansh" then how does teradata will retrieve the below query results :

Sel * from tablename where coulmnvalue ='Ansh';

2 REPLIES
Junior Contributor

Re: Compression In Teradata

Teradata uses a "Dictionary Compression" storing a list of compressed values within the table header and just a bit combination indicating the actual value within each row.

You'll find all the details within the "Database Design" manual:
Chapter 15: Database-Level Capacity Planning Considerations
Value Compression

Dieter
Enthusiast

Re: Compression In Teradata

Hi Dieter,
That means compression information is stored in table header ?
Could you please explain how the query I mentioned above will work in Teradata in little detail.

Thanks!!!