If you have spent any amount of time working with Teradata, you know that the Primary Index is one of the most important design decisions you make. It determines how data is distributed across AMPs and whether your joins are fast or slow. Choosing the wrong Primary Index is one of the most common causes …
There was a time when a single team could build an entire data warehouse. Not a team of forty. Not a team of sixty distributed across three continents and coordinated by a project management office that had never seen an execution plan. A team of five. Perhaps six, if one counts the person from Controlling …
1. The Forgotten Performance Trick: A Semicolon That Saves Time For decades, Teradata developers have quietly used one of the smallest but most powerful performance optimizations in BTEQ:a semicolon at the start of a line. This isn’t just a style choice.It tells Teradata to combine all statements into one multi-statement request, parsed and executed as …
At first glance, an UPDATE looks universal.In reality, it’s one of the most misleading similarities between Teradata and Snowflake.The SQL is the same, but the storage, logging, recovery, and performance mechanics are completely different. If you’re migrating from Teradata to Snowflake (or running both), understanding these differences prevents slow jobs, unnecessary costs, and avoidable outages. …
Introduction to Teradata Compression Note: Teradata Block Level Compression is now permanently enabled and cannot be turned off. Nonetheless, this article remains useful for current Teradata systems utilizing block-level compression. It demonstrates the continued advantages of multi-value compression (Teradata MVC). With Teradata’s introduction of block-level compression, the utilization of multi-value compression at various Teradata sites …
The Art of Teradata Performance Tuning As a Teradata Performance Tuner, technical expertise and experience are essential, occasionally accompanied by fortuitous circumstances. I’ll demonstrate the remarkable outcomes that can be attained by rephrasing a query using this example. Assuming this scenario: One table has a minimal number of rows, while the other is partitioned and …
Learn about Query Logging with Teradata DBQL Tables, a powerful feature for workload analysis and performance tuning. Configure settings and select which key figures to store and their level of detail. The article covers how to implement and activate DBQL tables, determine which information to collect, and analyze tactical queries.
The latest generation of Teradata systems always has Block Level Compression (BLC) enabled. When using MultiValue compression, the compression factor is typically low. How Block Level compression and MultiValue compression relate to each other is shown in detail in the article below: In this article, we will show you a trick on how to use …
Problem-solving without a Teradata Recursive Query To depict a corporate hierarchy in our instance, we can employ a non-recursive approach, illustrated by the query presented below: The above query has several harmful properties: Problem-solving with a Teradata Recursive Query The above recursive query has several benefits: The only modification required to enlarge the Company_Hierarchy column …
Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Miami, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.