Sign in Subscribe

Skew

A collection of 21 issues

Optimize Teradata UNION ALL with a Single Table Scan Trick

The Idea Behind This Trick for Teradata UNION ALL What if you need to apply a UNION ALL operation to distinct columns within a single table? Typically, the process would involve: SELECT CloseDate FROM Customer UNION ALL SELECT OpenDate FROM Customer ; The drawback of this method is that it scans

Optimizing Teradata Joins: Handling Skewed Workloads with Partial Redistribution and Partial Duplication

How does Teradata handle Skew in Joins? The imbalanced workload is a primary issue that must be addressed in performance optimization. Efficient optimization is crucial for join steps due to the possibility of Teradata transferring significant data volumes between AMPs. The optimizer can perform joins separately for primary index values

Teradata Sample Statistics: When, How, and Why to Use Them

Introduction to Teradata Sample Statistics Discover the optimal utilization of Teradata Sample Statistics, including when, how, and why to implement them. What is Teradata Sample Statistics? Sample statistics take only a percentage of rows into account when producing estimates. What are the Advantages of Sample Statistics?We use Teradata Sample

Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.

Teradata Query Parallelism A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data. Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high

Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table

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. 1.

Mastering Teradata Performance Optimization: Introduction to Partial Redistribution and Duplication

Introduction to Teradata Partial Redistribution and Partial Duplication Managing data skew is a critical aspect of optimizing Teradata performance. While table-level skew can typically be prevented by selecting an appropriate Primary Index, spool skew occurs during query execution - a common and often significant problem. Spool skew is a common

Optimizing Teradata Joins with Skewed Data: Strategies and Solutions

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. CREATE TABLE Currency ( CURRENCY_CD VARCHAR(20)

The Vulnerability of Outer Joins in Business Intelligence Tools: A Simple Test Scenario

Learn why business intelligence tools often use outer joins and why they can be vulnerable to skewing. Read on to understand the details and risks involved.

Teradata Skewing: Causes, Detection, and Solutions

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 performa

The Impact of Skewing on Teradata demonstrated

Learn how skewing on Teradata can impact query run times with this informative test scenario. Find key figures and observations to help optimize your performance.