Sign in Subscribe

Compression

A collection of 20 issues

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

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

Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER

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 through the databases, table by table, to find out what to compress on which column. Typically, this is

Teradata Multivalue Compression and Presence Bytes for NULL Values

Multivalue compression and null indication serve distinct purposes yet share a common objective of storing information about the values of each row's columns. To conserve space, Teradata utilizes presence bytes to retain information on multivalue compression and nullability. Readers familiar with earlier releases will recognize that the name

Is Teradata Compression Worth Your Time and Effort?

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 modif

How to Analyze Teradata Tables for Multivalue Compression: A Less Costly Method Using SHOW STATISTICS VALUES COLUMN ON

Learn how to analyze Teradata tables for Multivalue compression without costly operations by using the SHOW STATISTICS VALUES COLUMN statement. This method delivers excellent compression suggestions with less resource and time consumption than traditional approaches. However, it only works for colum

Introduction to Teradata Big Data Blocks: Advantages and Disadvantages

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

Implementing Teradata Compression: A Guide to Managing Data Warehouse Capacity and Saving Space

Learn how to use compression as a table column addition to manage your data warehouse's space effectively. Discover constraints and best practices.

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

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

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

Maximizing Teradata Table Performance with BLC, Row-Level Partitioning, and Data Block Size Tuning

BLC, Row Level Partitioning, and Datablock Size Tuning In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to influence the Teradata table size and, thus, performance. We will create a test scenario based on a customer master