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.
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.
Teradata Tuning: Fixing The Broken Data Model
Learn about the challenges of Teradata Performance Optimization from an expert. Discover why fixing a poorly designed data model is critical to success.