Learn about the Teradata row size limits and how to deal with the "3577 Row size or Sort Key size overflow" error in this informative article.

Teradata data access is categorized based on the number of AMPs involved and the technique employed to search rows within a data block. In our article about SQL Tuning, we mentioned that one of the main goals in performance optimization is to distrib...

Teradata 16 introduces a new option for handling sets of rows combined with "UNION ALL" in views and derived tables, reducing resource usage. The optimizer can apply aggregation steps and join operations to each branch of the "UNION ALL" separately,...

Learn about heuristics in Teradata optimizer and how they estimate the number of selected data rows for nonindexed columns in WHERE condition predicates. This post analyzes several queries and their estimates based on heuristics and provides insights...

Learn about referential integrity and how it ensures data consistency in databases. Discover soft referential integrity and its use in inner join elimination.

Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.

Learn about the Teradata Join Index, a performance tuning tool that stores pre-joined tables, aggregations, or table content in a different structure. Discover its benefits, what it is used for, and when to use it.

Learn how to handle errors in Teradata Stored Procedures. Error handlers provide event-driven functionality and make error handling more efficient.

Discover the exciting new features of Teradata Version 16.00, which can significantly improve data warehouse administration and loading. Learn how to avoid error messages and manage skewed tables with the new Global Space Soft Limit and SKEW features...

Learn about the Teradata Primary Index and how it differs from a primary key. Discover the benefits of defining a primary index and how many can be created per table.