DWHPro Insights

merge join

5 Things That Break When You Migrate from Teradata to Snowflake

Icon of a chrome hammer inside an orange circle over a brick pattern

Most organizations approach a Teradata-to-Snowflake migration as a translation exercise: convert the SQL, move the data, and validate the results. The technical migration succeeds. Then the first quarterly bill arrives at double the projected budget, dashboards queue for 20 minutes during batch windows, and data-loading pipelines that ran in 45 minutes on Teradata now take …

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

SQL Tuning Goals: Improving Performance and Reducing Resource Usage Widely read

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

Learn about the goals of SQL tuning and how to optimize database performance by reducing resource usage. Skew, IOs, and CPU seconds are key metrics. Discover how to ensure completeness and correctness of Teradata statistics, detect missing and stale statistics, and improve query plans.

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

Teradata Join Strategy: The Benefits and Costs of Merge and Product Join Methods Widely read

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

Teradata uses different join methods and data-placement strategies. Rows to be matched must meet at the executing AMP, which can require duplication, redistribution or sorting. Some methods need less preparation than others, but lower preparation cost does not mean zero geography or resource cost. We should consider the following costs in the join strategy: The …

Read more

Teradata MERGE INTO vs. UPDATE: Performance Comparison and Limitations Widely read

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

Teradata MERGE INTO vs. UPDATE This article compares the UPDATE statement to the MERGE INTO statement, analyzing their respective performance differences and limitations. The Teradata MERGE INTO statement positively impacts performance by reducing I/O operations through the following properties. The displayed historical MERGE plan avoids the update spool shown in the comparison. MERGE can use …

Read more

Teradata Tactical Workload Popular

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

Introduction This blog post discusses tactical workloads on a Teradata system. Despite Teradata’s implementation of features that support tactical workloads, this workload category remains challenging to manage. Selecting an optimal physical design is essential to meet user expectations for query speed. Designing the Teradata tactical workload on a test environment can be frustrating, especially when …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam