Sign in Subscribe

Teradata

A collection of 307 issues

Teradata Skewing: Causes, Detection, and Solutions

Learn how to detect and prevent Teradata skewing, one of the main causes of slow query performance. Discover the different types of skew and how to analyze tables, joins, and column values to detect and resolve issues. With practical tips and example queries, this article is a must-read for performa

Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks

Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back

Improving Teradata Load Performance: Choosing the Right Loading Method

Learn how to optimize your Teradata Load Performance by choosing the right loading method per table. Bulk loads for large tables and transactional loads for small ones. Find out more in this article.

Teradata vs Snowflake: A Comparison of Volatile and Temporary Tables

Introduction to Teradata Volatile Tables and Snowflake Temporary Tables Teradata and Snowflake offer temporary tables. This post will compare and contrast the types of tables available on each platform. We will examine table types found only in Teradata and Snowflake and show their ideal use cases. What is the equivalent

Teradata Architecture: The Pioneer of Data Warehousing

Learn about the basics of Teradata architecture and why it's still a top RDBMS for Data Warehousing. Discover how the system is built for parallelism and how hashing algorithms help distribute data evenly among AMPs. Explore the essential roles of Parsing Engines, AMPs, and Nodes in executing instru

Efficiently Adding New Partitions to a Row Partitioned Teradata Table: A Comparison of Alter Table vs Insert Select

Learn how to efficiently add new partitions to a Row Partitioned Table. We compare two methods, ALTER TABLE and INSERT…SELECT, with test results.

Solving Rounding Issues in Teradata: A Possible Solution

Learn how to handle rounding issues in Teradata with this helpful article. Discover a possible solution to a common problem and improve your results!

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution pl

Teradata Spool Space 101: Understanding, Managing, and Troubleshooting

Learn about Teradata Spool Space, a temporary workspace used to store intermediate and final result sets. Discover ways to increase and manage Spool Space.

Teradata SUBSTRING vs SUBSTR: Syntax, Parameters, Advantages

Learn the differences between Teradata SUBSTR and SUBSTRING functions for string manipulation. Discover the syntax variations, parameters, and usage examples.