Teradata Spool Space 101: Understanding, Managing, and Troubleshooting
Learn about Teradata Spool Space, a temporary workspace used to store intermediate and final result sets. Discover ways to increase and manage Spool Space.
SQL
A collection of 180 issues
Data Modeling Considerations for Teradata: SET and MULTISET Tables
Discover the differences between Teradata MULTISET and SET tables for effective data modeling. Learn how to avoid duplicates and improve performance.
Teradata FastLoad: Bulk Load Your Data Efficiently
Discover the power of Teradata FastLoad - the bulk load utility that efficiently loads vast amounts of data, bypassing the transient journal. Learn more here.
A Comprehensive Guide to Teradata Volatile Tables
Learn about Teradata Volatile Tables, their features, restrictions, and performance tuning possibilities. Find answers to common questions about their usage.
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
Teradata Intelligent Memory: A Smart Strategy for Balancing Data Access and Storage Costs
Discover the benefits of Teradata Intelligent Memory and its unique approach to storing data. Learn how it prioritizes frequently accessed data for faster access.
How to get SQL Query Stats in Teradata
Learn how to determine SQL Query Performance in Teradata with these three essential parameters: AMPCPUTime, TotalIOCount, and SpoolUsage. Discover how to get SQL Query Stats and make the right decision for your queries using the DBC tables DBQLOGTBL and DBQLSQLTBL. Follow these three points to consi
Understanding Teradata Parsing Engine and Access Rights: Impact on System Performance
Learn about the Teradata parsing engine's tasks and how it impacts overall system performance. Find out how to clean up the DBC. AccessRights table to improve parsing times in this informative article.
The Teradata NESTED join and the impact of the Primary Index
Discover the benefits of using a Teradata NESTED join strategy for economical data joining. Learn how to enable this feature and optimize query design.
The Impact of Skewing on Teradata demonstrated
Learn how skewing on Teradata can impact query run times with this informative test scenario. Find key figures and observations to help optimize your performance.