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

Filter efficiently with Teradata NOS Popular

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

Teradata NOS facilitates querying data in an S3 object store with ease. To attain maximum performance, partitioning external data is crucial for efficient reading. This article outlines the key considerations for optimal efficiency when reading data from the object store. Use an authorization method supported by the target object store and database release. The placeholders …

Read more

How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study

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

The historical threshold and performance results below have not been reproduced on the current release. A 20,000-row functional check confirmed that the former decimal literals 19.332 and 19.333 both selected only integer keys through 19, while 19332 selected keys through 19,332. The SQL cutoffs have been corrected. Teradata NUSI Selectivity and Data-Block Density The goal …

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

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.

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

Building a Teradata Data Warehouse: Considerations for ETL Process, SQL Queries, and Physical Data Model Popular

Illustration of a network graph with circular nodes joined by lines

This post aims to compile all crucial aspects to be considered while constructing a Teradata Data Warehouse, including the ETL process and SQL queries. This list is just the beginning, and I anticipate receiving valuable feedback from my readers to expand it in the future. Initially, I have provided a few concepts, but I intend …

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

Achieve Incredible Teradata Join Performance

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

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

Read more

The Impact of Character Sets on Teradata SQL Performance: A Case Study Popular

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

As a Teradata SQL specialist, I find skew to be a common challenge. In fact, approximately 90% of SQL performance difficulties stem from skew, based on my experience. However, this article focuses on the potential for minor modifications to yield significant improvements. This article highlights the potential consequences of selecting inappropriate character sets for SQL …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam