Architecture
A collection of 111 issues
Understanding Deadlocks in Teradata: Prevention and Handling Strategies
What are Deadlocks in Teradata?
Deadlocks arise when two transactions hold locks on database objects required by the other transaction.
Here is an example of a deadlock:
Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1
Teradata Row Retrieval: Understanding Hashing, Indexing, and Search Algorithms
Optimizing Performance with Teradata ORDER BY: How Sorting is Done in Parallel Without Bottlenecks
Teradata Join Strategy: The Benefits and Costs of Merge and Product Join Methods
Teradata employs various join methods and techniques to merge the rows of two tables onto a single AMP, which is essential for joining. The combination of join technique and data geography is called the join strategy, and its goal is to reduce resource consumption (CPU seconds, I/Os). Some join
Teradata Antiselect: Selecting All Columns Except the Ones You Exclude
Teradata has incorporated several analytical functions from Teradata Aster in its recent releases. Although many of these functions are tailored for web click analysis, Teradata Antiselect has proven valuable for specific applications.
What is the Teradata Antiselect function?
Teradata's Antiselect function allows for the reversal of column selection
Teradata Table Skew: Understanding Natural and Artificial Skew with DBC.TableSizeV
Teradata table skew is a common issue encountered while working with the Teradata database. If you're reading this page, you may have experienced this problem.
Common knowledge
When searching for Teradata table skew or skew factor online, most or all documentation will refer directly to DBC.TableSizeV for
Teradata vs SQL Server: Key Architectural Differences and Performance Implications
This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled "Teradata versus SQL Server" will be periodically updated.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested notes on