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. Each approach has unique benefits, drawbacks, and characteristics worth considering. Let’s examine two sequential statements as an illustration: Using Teradata Mode With Explicit Transaction These statements can be executed as …
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 is a pattern worth watching for in your own …
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: The drawback of this method is that it scans the Customer table twice. To achieve the same output with just one full table scan, …
This post aims to compile all crucial aspects to be considered while constructing a Teradata Data Warehouse, including the ETL process and SQL queries. This list is just the beginning, and I anticipate receiving valuable feedback from my readers to expand it in the future. Initially, I have provided a few concepts, but I intend …
The optimizer has various access paths to consider when creating the execution plan, each with unique advantages and disadvantages. This article will introduce the 8 most essential access paths. The lack of a hash index may surprise you; however, Teradata has entirely substituted it with the single-table join index and discourages its utilization in the …
Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing, and subject to …
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 that are skewed and those …
How Do I Select The Appropriate Data Type In Teradata? Converting datatypes incurs substantial costs and demands significant CPU resources when dealing with extensive tables. Incorrect data type selection hinders the execution plan. This article will discuss selecting appropriate data types for optimal performance. Consistency in selecting data types across different tables is crucial, as …
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.