Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk your way through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing, and

Read More

The importance of the PDM Compression is a popular way of saving IOs, by allowing to pack more rows into each data block. Data blocks are the smallest unit transferred between hard drives and main memory, the most expensive operation in any database system. Compression can be done automatically by the system (block level compression)

Read More

Multivalue compression and the indication of nullability are different matters, but with one common task: Collecting information about column values in every row. To keep space requirements low, Teradata stores information about nullability and multivalue compress in the so-called presence bytes. The alert reader might recognize that the name “presence byte” suggests that it indicates

Read More

Compression in Teradata Columnar offers two main benefits: Reduction in used permanent space and disk IOs. When dealing with the compression of columns, there is usually a significant advantage over row compression: A limited data variance per column. Teradata Columnar uses several compression methods which are exploiting this property. Teradata Columnar & Run-Length Encoding This compression method

Read More

Even though stage tables are only temporary objects, holding intermediate data, a conventional table design can differentiate between a good performing load and a load proceeding at a snail’s pace. The additional efforts are paying off soon. The correct choice of data types and sizes is essential. Some bytes have to be pushed into Teradata,

Read More

When Teradata compression becomes pressing Have you ever seen your data warehouse approaching space limits or some of your tables’ Current Perm skyrocketing as you start loading data? If so, use compression as an addition to your space management effort. Compression is a table column definition addendum whereby you define the most common values as

Read More