DWHPro Insights

merge join

The Importance of Up-to-Date Statistics for Teradata SQL Tuning Widely read

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

The DBQL example needs configured logging and a bounded time window. HASHAMP()+1 assumes the relevant map/AMP scope; it may misrepresent a request using only a subset of AMPs. Use the actual participating-AMP count for meaningful skew/impact calculations, and clear temporary query bands after the measured workload. 1. Complete and up-to-date Statistics At the start of …

Read more

Teradata vs. Redshift: A Comparison of Join Strategies and Architecture

Illustration of three stacked database units of differing heights inside a circle

Teradata and Redshift share similar architectures and data distribution methods. Teradata’s AMPs store portions of table data, while Redshift utilizes slices. There are notable differences in the way data is stored on file systems. Row/column storage and join-maintenance trade-offs are workload- and deployment-dependent. This article does not establish universal row-store superiority or lower operating effort. …

Read more

Optimizing Teradata Joins: Handling Skewed Workloads with Partial Redistribution and Partial Duplication Popular

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

How does Teradata handle Skew in Joins? The imbalanced workload is a primary issue that must be addressed in performance optimization. 🎓 Prefer video? Lecture 11 of my Udemy course Teradata Performance Tuning in Practice, “Skewed joins: partial redistribution and duplication”, covers this topic. See the course on Udemy → Efficient optimization is crucial for …

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

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations Popular

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

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …

Read more

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes Popular

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

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.

Teradata Sliding Window Merge Join: A Detailed Explanation Popular

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

Introduction to the Teradata Sliding Window Merge Join DWH Pro thoroughly analyzes the Teradata sliding window merge join, which has limited available information. Our extensive research provides valuable insights into this process. 🎓 Prefer video? Lecture 10 of my Udemy course Teradata Performance Tuning in Practice, “Sliding-window merge join on partitioned tables”, covers this topic. …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam