Snowflake’s physical join execution is predominantly hash-based. In practice you’ll observe hash-join variants with two distributions: If you come from Teradata, the intent will feel familiar: both systems aim to co-locate equal keys before matching. This article explains Snowflake’s strategies, maps them to Teradata’s (including dynamic plan fragments), and shows how to recognize and mitigate …
Introduction In a row-oriented database engine like Teradata, data is organized and stored in units called data blocks. Each data block features a fixed header and accommodates multiple rows. Every row consists of a record header followed by its corresponding columns. When a database retrieves and stores a data block in the cache, it accesses …
Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. The paired table rows must reside on identical AMPs. The chosen method for joining and relocating data is called a join strategy. The preparation for each join method varies. The choice of Teradata join strategy utilized by the Optimizer is determined by …
The Art of Teradata Performance Tuning As a Teradata Performance Tuner, technical expertise and experience are essential, occasionally accompanied by fortuitous circumstances. I’ll demonstrate the remarkable outcomes that can be attained by rephrasing a query using this example. Assuming this scenario: One table has a minimal number of rows, while the other is partitioned and …
Introduction Relational databases are essential for contemporary data management and analysis. Joining tables, which merges data from two or more tables based on a shared column or condition, is a fundamental operation in these systems. Various join methods exist in relational databases, each with unique advantages and disadvantages. This article examines the different join methods, …
It’s time to share a new Teradata SQL tuning case study that showcases the impressive impact of query rewriting on performance. We are studying the query below that originally took 40 minutes to run. As a SQL tuning specialist, I always prioritize adding missing statistics and refreshing stale ones. I analyzed the SQL statement that …
What is Teradata Join Estimation? This article demonstrates the functioning of Teradata Join Estimation in the absence of statistics. It presents the heuristics employed to estimate row count and emphasizes the importance of collecting statistics on all join columns. Teradata Join Estimation Heuristics The worst-case scenario involves joining two tables without any collected statistics. We …
1. Outline This showcase demonstrates optimizing statements with multiple JOINs using Teradata Optimizer’s tuning approach. The approach efficiently determines the best JOIN strategy and implements data redistribution instead of duplication when necessary. Identify and break down underperforming segments to optimize complex logic with multiple joins. Employ an execution plan and monitor query performance and resource …
How Do I Select The Appropriate Data Type In Teradata? Converting datatypes incurs substantial costs and demands significant CPU resources when dealing with extensive tables. Incorrect data type selection hinders the execution plan. This article will discuss selecting appropriate data types for optimal performance. Consistency in selecting data types across different tables is crucial, as …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.