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
Introduction
Data lakes have gained significant popularity in recent years as organizations seek more flexible and scalable solutions to store and process their ever-growing volumes of data. While data lakes offer numerous advantages over traditional data storage and processing systems, they also have their fair share of challenges and pitfalls.
Teradata Vantage now available in AWS, Microsoft Azure, and Google Cloud Storage with Teradata Native Object Store (Teradata NOS)
Teradata Vantage has also made its move into the public cloud. Teradata Vantage is now available in AWS, Microsoft Azure, and Google Cloud Storage. It is worth noting that the same Teradata software runs on these three major cloud providers. This makes it relatively easy to run Teradata on-premise and
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
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