Maximizing Efficiency: Teradata vs. Snowflake Partitioning
Learn how Teradata and Snowflake minimize IOs to enhance performance. Teradata uses row partitioning while Snowflake relies on micro-partitions.
Architecture
A collection of 111 issues
5 Tips for Optimizing Teradata SQL Queries: Avoiding Joins, Functions, Union, and Group By
Is Teradata-Specific SQL different from SQL?While the SQL Teradata uses is a dialect of SQL, there are some differences compared to ANSI SQL. It is specifically designed for the Teradata architecture, focusing on parallel processing and scalability. While it supports most of the standard SQL features, some additional functions,
Understanding the Downsides of Data Lakes: Challenges and Pitfalls to Consider
Teradata Vantage now available in AWS, Microsoft Azure, and Google Cloud Storage with Teradata Native Object Store (Teradata NOS)
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.
The Teradata MAPS Architecture – Great Performance with All Rows on One AMP
How to use the Teradata MAPS Architecture?
In an earlier article (link to All Rows on One AMP – By Design), I showed an alternative design for small reference tables, ensuring that all rows in the table are stored on a single Teradata AMP using the Teradata MAPS architecture. The design
Understanding Teradata NOPI Tables: Essential Facts and Performance Benefits
The Essential Facts About NOPI Tables in Teradata
What are Teradata NOPI tables?The rows of a Teradata NOPI table are not distributed evenly across all AMPs using the hashing algorithm, as with a primary index. They are not intended to replace primary index tables but are used in certain
Understanding Teradata AMPs and their tasks in a Teradata system
What is a Teradata AMP?Teradata AMP (Access Module Processor) is a critical component in the Teradata system, responsible for managing and processing its data share. Each AMP operates as a Linux process, ensuring the even distribution of data rows across all AMPs using a hashing algorithm. Teradata systems, being
Understanding Teradata Secure Zones: A Clear Explanation and Possible Use Cases
Teradata Secure Zones
I've had a few conversations recently with different customers about the "Secure Zones" optional feature added in Teradata 15.10. There is a fair amount of misunderstanding about what this feature offers and does.
This article aims to provide some clear information for