Maximizing Performance with Teradata Sparse Maps: An Introduction

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

Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to split tables for maximum parallelism evenly have been unchanged since the beginning. What is new is the ability to create your hash maps. Hash maps, as we usually know them, are also called contiguous maps. If you are not familiar …

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

Protected by Security by CleanTalk and CleanTalk Anti-Spam