DWHPro Insights

statistics

Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions

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

Teradata Statistics Histograms – A Short Introduction Many are familiar with the Optimizer’s statistical confidence levels. I was recently surprised to discover that a “high confidence” rating does not guarantee a fully accurate estimation (provided the statistics collected are not stale). While I remain hopeful that my observations may be attributed to a bug, I wanted …

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

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.

Understanding Teradata DBQL Tables and Query Logging Most read

Illustration of a person in a suit standing beside a database cylinder

Learn about Query Logging with Teradata DBQL Tables, a powerful feature for workload analysis and performance tuning. Configure settings and select which key figures to store and their level of detail. The article covers how to implement and activate DBQL tables, determine which information to collect, and analyze tactical queries.

Teradata Set Operators: Understanding UNION vs. UNION ALL for Peak Performance Optimization Most read

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

In this article, we will delve into the world of Teradata set operators, exploring their functionality, applications for attaining peak performance, and the optimization techniques employed by Teradata. 🎓 Prefer video? Lecture 17 of my Udemy course Teradata Performance Tuning in Practice, “GROUP BY vs DISTINCT, UNION vs UNION ALL”, covers this topic. See the …

Read more

Optimizing Teradata Performance through Statistics and Primary Index Selection Widely read

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

1. Statistics In Teradata, understanding and managing statistics is essential for optimizing database performance. Statistics provide the optimizer with precise data about stored information, allowing for well-informed decisions when handling queries. This article will explore the significance of statistics in Teradata, their effect on query performance, and recommended methods for upkeep. The Role of Statistics …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam