Table Skew Archives - Page 4 of 4

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

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of three stacked database units of differing heights inside a circle

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 levels of parallelism from the start, even …

Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table

04/11/202604/28/2023 by Roland Wenzlofsky

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. Since this is a system table, altering …

How to Improve Cardinality Estimations in Teradata: The Optimizer’s Toolkit

04/11/202604/28/2023 by Roland Wenzlofsky

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

Learn about Teradata Heuristics and Optimizer’s approach to estimating cardinality for non-indexed columns in this article. Discover how skew improves estimations and why heuristics should be avoided.

Optimizing Teradata Joins with Skewed Data: Strategies and Solutions

04/11/202604/23/2023 by Roland Wenzlofsky

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. CUSTOMER TABLE CUSTOMER_ID CUSTOMER_NAME CURRENCY_CD 1 Nina Lowery EUR 2 Alexia Neal USD …

Teradata Skewing: Causes, Detection, and Solutions Widely read

04/11/202604/21/2023 by Roland Wenzlofsky

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

04/11/202604/21/2023 by Roland Wenzlofsky

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.

The Impact of Skewing on Teradata demonstrated

04/11/202604/21/2023 by Roland Wenzlofsky

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.

Never Again “No More Room In Database”. I’ll Show You How! Most read

04/11/202604/20/2023 by Roland Wenzlofsky

Discover the exciting new features of Teradata Version 16.00, which can significantly improve data warehouse administration and loading. Learn how to avoid error messages and manage skewed tables with the new Global Space Soft Limit and SKEW features.