#block level compression

[sevenpips]

Teradata Compression: Should you bother?

Teradata Compression: Should you bother?

The Teradata DBMS has always supported compression in a (growing) number of forms. Version 5.0 introduced Multi-Value Compression (MVC), version 13.10 introduced Algorithmic (ALC) and Block Level (BLC) compression and version 14.0 introduced multiple automatic compression options for Columnar tables.

All of these can produce disk space and associated performance savings; however implementing…

View On WordPress

[sevenpips]

Teradata Multivalue Compression - a Quick Approach

Teradata Multivalue Compression – a Quick Approach

Whenever you have to analyse a huge Teradata table regarding multivalue compression, this is a costly operation. Usually, it involves the counting of the number of distinct values per table column. This can be resource and time intense.

Luckily, with Teradata 14.10 we have another method available which is much cheaper from a resource point of view but less comprising:

SHOW STATISTICS VALUES…

View On WordPress

[sevenpips]

Teradata Block Level Compression - BLC

Teradata Block Level Compression – BLC

What is Block Level Compression (BLC) and how does it work?

Block Level Compression (BLC) is a feature which was introduced with Teradata 13.10 and allows for compression of entire data blocks, contrary to other compression methods which are applied on column level (MVC,ALC)

Whenever you decide to apply block level compression on a table, the entire data blocks are being compressed and stored on…

View On WordPress