DWHPro Insights

Table Skew

Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table

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

As any experienced Teradata DBA will tell you, some tables in the Teradata dictionary (DBC) need housekeeping. But some customer sites that I have worked with ignore table DBC.AccessRights. If you have ever analyzed this table on a Teradata system, you will almost certainly spot two things quickly. Do not modify DBC.AccessRights directly. Fewer rows …

Read more

Optimizing Teradata Joins with Skewed Data: Strategies and Solutions

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

Skewed Teradata Joins – The Initial Situation Consider the scenario where one table includes various currencies while the other comprises customers’ accounts with their corresponding currency. Essentially, the ISO code of the currency serves as a foreign key in the account table. 🎓 Prefer video? Lecture 11 of my Udemy course Teradata Performance Tuning in …

Read more

Teradata Skewing: Causes, Detection, and Solutions Widely read

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

Learn how to detect and prevent Teradata skewing, one of the main causes of slow query performance. Discover the different types of skew and how to analyze tables, joins, and column values to detect and resolve issues. With practical tips and example queries, this article is a must-read for performance tuners and database administrators.

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.

Protected by Security by CleanTalk and CleanTalk Anti-Spam