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

Illustration of a stopwatch dial on an orange paint-splash background

BLC, Row Level Partitioning, and Datablock Size Tuning The sizes and diagrams below are historical observations: the original data, allocation and effective BLC policy are unavailable, so they have not been reproduced. 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 …

Read more

The Teradata MAPS Architecture – Great Performance with All Rows on One AMP Popular

Illustration of three stacked database units of differing heights inside a circle

For a history table, ref_code alone cannot be unique when several versions of a code must coexist. The large-table example therefore uses a nonunique primary index. Define any required version uniqueness separately, and enforce the rule for identifying the current row. How to use the Teradata MAPS Architecture? In an earlier article (link to All …

Read more

Understanding Teradata AMPs and their tasks in a Teradata system Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

The components around the AMP are covered separately: how the PE, BYNET and AMP divide the work and a short overview of the architecture. 🎓 Prefer video? Lecture 2 of my Udemy course Teradata Performance Tuning in Practice, “Shared-nothing parallelism: nodes, PEs and AMPs”, covers this topic. See the course on Udemy →

Protected by Security by CleanTalk and CleanTalk Anti-Spam