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 Volatile Tables. Remember, denormalization can improve performance but has significant drawbacks and should be used only when necessary.
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 Permanent Journaling: Snapshot Your Tables Before and After Changes
The Teradata Permanent Journal captures permanent table snapshots pre- and post-modifications. Prior to any changes, the original row duplicates are saved in the permanent journal table. This mirrors the behavior of the transient journal table, which stores BEFORE images of tables when a transaction begins. Journaling can be implemented at the table or database level. …
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 to create and use USI effectively, and why recent statistics and high selectivity are important factors to consider. Don’t miss out on this unique insight into Teradata indexing!
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 consider while running the query and get accurate results.
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.