Teradata Data Type Considerations Most read

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

Introduction to Teradata Data Types Further Data Type considerations require occasional attention to additional issues. Happenstance Nullability Strive for nullability settings that adhere to the data model and are consistent throughout all tables. Allowing mandatory columns to be left open for null entries incurs costs for both storage and optimization. An additional presence bit per …

Read more

Teradata – Merging two change history tables

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

Have you encountered a poorly designed physical data model where object columns are distributed randomly across tables, and you wish to unify them in their rightful place? Merging non-historical tables is simple, but the process becomes more complex when historization is applied to at least one of the tables. The fragments below illustrate interval overlap; …

Read more

Collect Statistics in Teradata – Evaluation

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

Collect Statistics in Teradata – The Evaluation After collecting every combination considered necessary and helpful, you can check the result of the collected statistics on a table by looking at Consider the lengthier collection time when planning maintenance and scheduling, even within regular or optimal conditions. Simplify and maintain the collection method, particularly for smaller tables …

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

How Teradata Optimizer Uses Multi-Column Statistics Popular

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

Start with the tested SQL: The practical Teradata statistics guide includes COLLECT STATISTICS syntax, before-and-after EXPLAIN estimates, sampling and recollection examples tested on Teradata 20.00.28.81. The specialist examples below retain their original release context and were not retested in that lab. A recent question came in about how the Teradata Optimizer uses multi-column statistics. Here …

Read more

Real-World Map-Reduce Implementations: Design and Fault Tolerance

Illustration of a network graph with circular nodes joined by lines

This describes the classic MapReduce model at a conceptual level. Hadoop YARN has different coordination and recovery behavior; the details depend on version and configuration. How the Components Fit Together The input files reside in a distributed file system, such as HDFS for Hadoop, or GFS as Google calls it. Worker processes handle mapper or …

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.

Protected by Security by CleanTalk and CleanTalk Anti-Spam