Using Sparse Maps in Teradata 16.10 for Efficient Distribution of Small Tables Across AMPs
Teradata sparse maps place small tables on one or a few AMPs. Learn how map choice, table placement and workload affect access and performance.
Maximizing Performance with Teradata Sparse Maps: An Introduction
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 …