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 optimize SQL tuning on Teradata by minimizing I/Os and maximizing parallelism, which can be achieved by evenly distributing rows across all 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
Learn how Teradata applies two effective join optimization methods, Early and Partial GROUP BY, for decision support workloads with lots of aggregations. These transformations reduce resource usage and are widely used in modern databases. Discover how to improve the optimizer’s chance to apply these techniques by collecting statistics on all join and aggregation columns.
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
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.