How to Improve Your Teradata Vantage Historisation Design: A Systematic Approach
Situation and Setup of a Historisation in Teradata Vantage Imagine that the time has come to improve your physical…
Read article →
Teradata ALTER Table vs. INSERT INTO: Which Method is More Efficient?
Teradata ALTER Table versus INSERT INTO Altering the structure of a substantial Teradata table can consume significant…
Read article →
Improving Query Performance with Teradata Statistics Extrapolation and Object Use Counts (OUC)
Teradata introduced several new features, including one that caught our attention: object use counts (OUC). This feature…
Read article →
Optimizing Teradata Queries: From No Index to Hashed NUSI
The initial situation without any index In this blog, I will demonstrate how to optimize a query using Teradata’s tools.…
Read article →
Understanding Teradata Hash Collisions: A Case Study and Best Practices
To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are…
Read article →
Teradata Rollbacks: Understanding the Impact on Performance and How to Avoid Them
How to Abort the Teradata Rollback Executing a DML statement on a sizable table may trigger a prolonged ROLLBACK. In…
Read article →
The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance
Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve…
Read article →
Customize Your Redshift Workload Management System for Optimal Performance
Access the Amazon Redshift Documentation here: https://aws.amazon.com/de/redshift/ Access the Amazon Redshift…
Read article →