Architecture
A collection of 111 issues
When Teradata Space Shortage Impacts System Performance
Running out of free Cylinders in Teradata
Encountering a situation where free cylinders are exhausted is a significant concern when managing a system, and no more Teradata Space is available. It's an issue that can adversely impact the operations and efficiency of the database, leading to potential slowdowns
Improving Stored Procedure Performance with Teradata MAPS Architecture
Date ranges and business calendars beyond recursion and Teradata SYS_CALENDAR
Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More
This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two platforms to understand their distinctions and overlaps, despite their different architectures.
Clustered Index vs Teradata Row Partitioning
The SQL Server's clustered index arranges table rows in a specific physical
A Beginner's Guide to Teradata Multiload and Fastload
How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study
Hadoop and Teradata Data Warehousing: A Comparison and Integration Perspective
Hadoop is a buzzword in the world of big data, but its actual value can be concealed by the hype. This article compares Teradata and Hadoop Data Warehousing, highlighting the advantages of leveraging Hadoop's scalability and preprocessing capabilities to improve Teradata's performance. However, the
Teradata GROUP BY vs. DISTINCT- Aggregation Methods
Learn about the differences between GROUP BY and DISTINCT for aggregations in Teradata. The optimizer now selects the appropriate algorithm depending on data demographics. Understand when to use each method to optimize query performance.
Understanding Teradata Locking: Types and Granularity
Learn about locking in Teradata to ensure data integrity and consistency. Teradata automatically selects the best lock for each situation to prevent data inconsistencies.