322 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Learn how Teradata Integrated Workload Management assigns workloads to queries and offers features like filters and throttles to improve system performance.
Teradata 16.10 introduces Sparse Maps, a feature to place small table rows on one AMP. Learn more about how it can optimize your system here.
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 distribute the workload evenly across all AMPs. Using a single AMP is best …
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, resulting in smaller spool sizes and improved performance.
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 on how to replace heuristic estimations with more accurate ones.
Learn about referential integrity and how it ensures data consistency in databases. Discover soft referential integrity and its use in inner join elimination.
Learn how to optimize joins in Teradata with this case study. Discover how simple changes in query text can improve query performance.
Natural skew may hinder join performance, but the PDPR capability in Teradata 14 can alleviate this problem. However, PDPR may not detect all potential applications if skewed values are not evident in the statistics. If your Teradata version is below 14, PDPR is unavailable. To address this, you can use a technique based on the …
Learn how express requests work in Teradata, bypassing stages like syntax checking and permission checking, and how Teradata 14.10 offers a new feature to expedite them.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.