BLC Archives -

Maximizing Performance and Space Savings: Teradata Compression Techniques

04/11/202605/05/2023 by Roland Wenzlofsky

Introduction to Teradata Compression Note: Teradata Block Level Compression is now permanently enabled and cannot be turned off. Nonetheless, this article remains useful for current Teradata systems utilizing block-level compression. It demonstrates the continued advantages of multi-value compression (Teradata MVC). With Teradata’s introduction of block-level compression, the utilization of multi-value compression at various Teradata sites …

Shrinking Teradata Tables: Reduce Table Size by 90% with This Simple Trick

04/11/202604/28/2023 by Roland Wenzlofsky

Despite implementing Multivalue Compression to minimize the size of our tables, we still require additional space. Shrinking A Teradata Table To A Minimum Size I once used a trick that reduced an already optimized table with multivalue compression to just 10% of its original size. This is a pattern worth watching for in your own …

Is Teradata Compression Worth Your Time and Effort?

03/08/202604/28/2023 by Roland Wenzlofsky

Teradata DBMS offers various compression options to save disk space and improve performance. But, the cost of implementing the compression takes man-time. This article discusses the cost vs. benefit of compression and suggests carefully considering the compression setting when designing new or modifying existing tables.

What is Block Level Compression (BLC) and How Does it Work for Teradata?

04/11/202604/23/2023 by Roland Wenzlofsky

Block Level Compression (BLC) is a feature that allows compression of entire data blocks, leading to disk space reduction. Read on to know more.

The Importance of PDM in Database Compression and Resource Usage Optimization

04/11/202604/23/2023 by Roland Wenzlofsky

The importance of the PDM Compression is a widely used method for reducing IOs by enabling the accommodation of more rows in each data block. Data blocks are the smallest unit exchanged between hard drives and main memory, which is the most costly operation in any database system. Compression can be automated through block-level compression …