Performance Tuning
A collection of 267 issues
Understanding Teradata Load Isolation
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
Shrinking Teradata Tables: Reduce Table Size by 90% with This Simple Trick
Optimize Teradata UNION ALL with a Single Table Scan Trick
Teradata Access Paths: 8 Essential Ones to Know
Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER
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
Optimizing Teradata Joins: Handling Skewed Workloads with Partial Redistribution and Partial Duplication
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