Teradata FastLoad: Bulk Load Your Data Efficiently Popular
Discover the power of Teradata FastLoad – the bulk load utility that efficiently loads vast amounts of data, bypassing the transient journal. Learn more here.
Teradata Volatile Tables: CREATE Syntax and Session Rules Widely read
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 Popular
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
Explore historical Teradata 14.10 Intelligent Memory and data-temperature concepts. Check feature availability and storage behavior for the deployed platform.
Teradata Permanent Journaling: Snapshot Your Tables Before and After Changes
Permanent journals store configured before and/or after images of changes, not whole-table snapshots before each transaction. Transient journaling also records recovery information for changes rather than an upfront copy of the entire table. Journaling can be implemented at the table or database level. Even if database-level journaling is enabled, individual tables can have journaling disabled …
Teradata Unique Secondary Index: Everything You Need to Know Popular
Understand Teradata unique secondary indexes, their alternate access path and one- or two-AMP lookups. Consider uniqueness constraints before dropping an index.
A Brief History of Parallel Database Architectures and Their Limitations Popular
Review shared-memory, shared-disk and shared-nothing database designs, with deployment-specific fault tolerance and historical Hadoop integration context.
How to get SQL Query Stats in Teradata Popular
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
Understand parsing-engine access checks and why creator grants are not automatically redundant. Evaluate ownership and effective privileges before changing rights.