Teradata Tuning Ideas: Best Practices and Strategies
Learn how to optimize Teradata performance with these general tuning ideas. From changing one parameter at a time to testing on the target system.
Practical Approach for Teradata SQL Tuning: Finding the Root Cause of Performance Issues Most read
To optimize Teradata SQL performance, it is crucial to identify the root cause of any issues. The SQL statement itself is typically not the culprit but rather one or more stages of the execution plan. This article does not cover genuine optimization techniques. Instead, it presents a pragmatic method for query optimization. I have noticed …
Teradata SQL Tuning: Minimizing Costs and Maximizing Parallelism
Learn how to tune Teradata queries by measuring I/O, CPU and execution skew. Even row distribution helps, but does not guarantee equal work across AMPs.
Analyzing and Fixing Teradata Statistics Estimation Problem
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.
Improving Teradata Performance with SQL Query Rewriting
Learn how to improve the performance of SQL statements by rewriting them through this article on Teradata tuning. Follow along as we analyze a high-runtime SQL statement and optimize it to significantly reduce disk I/O and spool space usage.
Teradata SQL Performance: IN vs BETWEEN and the Use of Statistics on Columns
Learn about optimizing SQL queries in Teradata 14.10 by analyzing the execution plan of two queries and using statistics on columns and expressions.
Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload
Explore early and partial GROUP BY optimization in Teradata. Collect workload-relevant statistics and inspect operator order to confirm aggregation placement.
Why Selecting Only Needed Columns Boosts Performance: Teradata Query Example
Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.
Efficiently Adding New Partitions to a Row Partitioned Teradata Table: A Comparison of Alter Table vs Insert Select Popular
Learn how to efficiently add new partitions to a Row Partitioned Table. We compare two methods, ALTER TABLE and INSERT…SELECT, with test results.
Teradata Denormalization for Performance Tuning
Avoid data warehouse project failures by choosing the right data model. In this article, we explore denormalization techniques for when it makes sense, including repeating groups, prejoins, and derived information. We also discuss alternatives to denormalization, such as Global Temporary Tables and Volatile Tables. Remember, denormalization can improve performance but has significant drawbacks and should be used only when necessary.