Block Level Compression 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 …

Teradata Index Selection: Factors to Consider

03/08/202605/05/2023 by Roland Wenzlofsky

The Teradata Tutorial to support the selection of indexes

Understanding Teradata DBQL Tables and Query Logging

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

Learn about Query Logging with Teradata DBQL Tables, a powerful feature for workload analysis and performance tuning. Configure settings and select which key figures to store and their level of detail. The article covers how to implement and activate DBQL tables, determine which information to collect, and analyze tactical queries.

Teradata Table Skew: Understanding Natural and Artificial Skew with DBC.TableSizeV

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

Teradata table skew is a common issue encountered while working with the Teradata database. If you’re reading this page, you may have experienced this problem. Common knowledge When searching for Teradata table skew or skew factor online, most or all documentation will refer directly to DBC.TableSizeV for computation. To analyze table skew, the commonly used …

Save Space with Teradata: Utilizing Block Level Compression and Row Partitioning

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

The latest generation of Teradata systems always has Block Level Compression (BLC) enabled. When using MultiValue compression, the compression factor is typically low. How Block Level compression and MultiValue compression relate to each other is shown in detail in the article below: In this article, we will show you a trick on how to use …

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.

Introduction to Teradata Big Data Blocks: Advantages and Disadvantages

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

Teradata Big Data Blocks – Introduction Teradata 13.10 introduced larger file systems components, such as cylinders and data blocks. The cylinder size was increased from 1.9 MB to 11.3 MB, while the data block size limit was raised from 127.5 KB to 1 MB in Teradata 14.10. Teradata 14.10 allows temporary rows in spool space …

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 …