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
A collection of 307 issues
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 Data Loss Protection: Transient Journal, Fallback, RAID 1, and Clique
Learn how Teradata protects your data against potential loss with its various features. Each feature offers unique protection on different levels.
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.
Teradata Unique Secondary Index: Everything You Need to Know
Learn about Teradata's unique secondary indexes (USI) and how they provide an alternate access path to reduce disk IOs while retrieving data. This article explains the technical differences between USI and other indexes, and provides detailed information on the data retrieval process. Discover how t
A Brief History of Parallel Database Architectures and Their Limitations
Discover the history of parallel database architectures - from shared memory to shared disk and shared-nothing. Learn about the advantages and limitations of each architecture and how fault tolerance is handled. Explore the shift towards big data and the trend of "Hadoop over SQL."
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.