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 …
Learn an unusual trick to improve the performance of joining partitioned tables with different primary indexes or partitioning. Read on to find out more.
Learn about Teradata Statistics Extrapolation, a technique that allows for reasonable estimations when querying historical data with stale statistics.
Get a Grip on Clumpy Row Distribution – the Teradata PPI Table. For this technique to work properly, the primary index in Teradata should not include the partition column(s). We have all encountered the issue of slow table inserts, where the distribution of rows across all AMPs is even, but the merge step takes excessive time. …
Learn the truth about Teradata statistics and their impact on system performance. Address common misconceptions, follow best practices, and optimize your system for peak performance.
Learn how to use compression as a table column addition to manage your data warehouse’s space effectively. Discover constraints and best practices.
Teradata offers various options for designing Partitioned Primary Index Tables. The optimal design choice depends on the anticipated workload. This article examines the impact of partitioning methods on the access path selected by the Teradata Optimizer, ultimately influencing system performance. To begin, a test scenario is required, which consists of two identical tables. The sole …
Learn about the Teradata Nested Join, the cheapest join method using indexes. We explore its prerequisites, variants, and performance.
Fast Path INSERT/SELECT efficiently loads a single table. Requirements for Teradata Fast Path INSERT /SELECT How does the Fast Path INSERT/SELECT work? This reduces access to mass storage (such as hard disk or solid-state disk). The process involves generating complete data blocks on every AMP and subsequently transferring them to mass storage using a single …
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 …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.