Block Level Compression (BLC) is always enabled in the latest generation of Teradata systems. Usually, the compression factor is very low when Multi Value compression is used additionally. 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

To understand the problem of hash collisions in Teradata, I will give a short overview of how rows are distributed in Teradata. If you are not familiar with Teradata Architecture or have forgotten the details, I recommend reading the following article first: As you already know, a table’s rows are distributed to the AMPs using

Why I/Os are so important in Teradata The minimization of I/Os in Teradata is one of the most important goals in performance tuning. I/Os are necessary to copy data from storage to main memory. Data can only be processed if it is in the main memory. The process of copying data into the main memory

Both Teradata and Snowflake offer temporary tables. In this blog post, I’ll show you which types of tables Teradata and Snowflake provide, what similarities and differences they have. We will also look at table types that are only available in Teradata or only in Snowflake. I will show you what these can best be used

Often we have already reduced the size of our tables immensely using Multivalue Compression, and yet we need more space. Shrinking A Teradata Table To A Minimum Size I used once a simple trick for you that has allowed me to reduce a table already optimized with multivalue compression to 10% of its size. This

By way of introduction, I would like to mention that Teradata block-level compression is often performed by default nowadays. Therefore, this blog post’s considerations are only useful on Teradata systems, where this is not the case. Since Teradata Block Level Compression has been around, I often see that multi-value compression is not used. First, I