Skewed Joins, Straight Answers: A Neutral Guide for Snowflake/Teradata Teams Popular

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

The Pitfalls of Teradata SELECT * Queries Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

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. 🎓 Prefer video? Lecture 16 of my Udemy course Teradata Performance Tuning in Practice, …

Read more

Teradata Join Strategies: Merge, Hash, Nested and Product Joins Most read

Illustration of a stopwatch dial on an orange paint-splash background

Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. 🎓 Prefer video? Lectures 8 and 10 of my Udemy course Teradata Performance Tuning in Practice cover this topic: “Merge, hash, nested and product joins” and “Sliding-window merge join on partitioned tables”. See the course on Udemy → The paired table rows …

Read more

Teradata Performance Tuning: A Practical Guide

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Exploring the Different Join Methods in Relational Database Systems: Pros, Cons, and Use Cases Popular

Illustration of a stopwatch dial on an orange paint-splash background

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, …

Read more

Optimizing Teradata Statements Containing Multiple JOINS

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Choosing the Right Teradata Data Types Widely read

Illustration of a stopwatch dial on an orange paint-splash background

How Do I Select The Appropriate Data Type In Teradata? Converting data types 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, …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam