Accessing data has always been the bottleneck of database systems. Once the data resides in the main memory, it can be promptly processed. Although SSDs are now predominantly used instead of hard disks, copying data into the main memory remains the slowest. The Teradata Write-Ahead Logging (WAL) feature enhances DML performance and boosts data security.
Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index. This blog post will demonstrate a Primary AMP’s benefits and optimal usage for improving load and query performance. Initially, let us examine Teradata’s approaches throughout the years …
In this blog post, I will show you what you need to pay special attention to when switching from Teradata to Snowflake. We will analyze the impact of running DML statements (e.g. UPDATE or DELETE) in Snowflake and contrast it with Teradata’s Row Storage and Column Storage.
What Are Zero-Copy Clones? We are all familiar with creating table backups before performing specific operations. This is not a significant problem for smaller tables as duplicates can be swiftly produced and any errors can be rectified by reverting to the backup table. If the table is enormous, making a copy can take a long …
Introduction to Teradata in the Cloud Cloud databases are pressuring traditional data warehousing MPP systems. This blog will illustrate the reasons for this and outline the pros and cons of each database system. The Architecture Of A MPP Database System MPP database systems employ a shared-nothing architecture, wherein each node possesses its own CPU, main …
This post will contrast the architecture of two widely-used database systems. The similarities between Teradata and Amazon Redshift are notable, as much of your knowledge about Teradata can be applied to Amazon Redshift. Although Amazon Redshift stores data in columns permanently, the similarities remain significant. Teradata can store data in columns, though it was not …
Isolation Levels and their Impact on Performance & Concurrency Isolation is a crucial factor in determining the visibility of transaction integrity to database users. This property guarantees that concurrently executed transactions produce identical results to those executed sequentially. Nonetheless, relinquishing this requirement can enhance transaction concurrency, improving performance. However, this also implies accepting inconsistent outcomes. …
What Are The Main Characteristics Of Transactions in Teradata? The Teradata Mode For Transactions Various techniques exist for composing SQL statements and applying transaction handling. It is imperative to contemplate each approach’s unique benefits, drawbacks, and characteristics. Let’s examine two sequential statements as an illustration: Using Teradata Mode With Explicit Transaction These statements can be …
Despite implementing Multivalue Compression to minimize the size of our tables, we still require additional space. Shrinking A Teradata Table To A Minimum Size I once used a trick that reduced an already optimized table with multivalue compression to just 10% of its original size. This unique situation is worth monitoring for potential opportunities. I …
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: This method has a drawback: To query the Customer table with just one full table scan and no need for UNION ALL, I sought …
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.