Decomposable Columns: Definition, Impact on Performance, and Workarounds
Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.
Roland Wenzlofsky
Improving Query Optimization with Teradata IPE
Learn about Teradata IPE, a technique that uses additional information collected during query execution to create execution plans in fragments.
The Importance of PDM in Database Compression and Resource Usage Optimization
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.
Throttles in Teradata Workload Management: Usage, Request and Session Limits
Teradata Concurrency Control: Locking and Transactions Explained
Learn how Teradata Concurrency Control uses locking and transactions to prevent simultaneous updates, deletions, or insertions in different sessions.
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.
The Importance of Avoiding SQL Functions on WHERE Condition Columns for Optimizer Performance
Learn why it's important to be careful when applying SQL functions on WHERE condition columns and how it can impact query performance.
Improve Query Performance by Using the Teradata CLOB Datatype for Storing Longer Texts
Learn how the Teradata CLOB datatype can improve query performance and reduce resource consumption for storing longer texts in your database.