Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …
All-AMP and single-AMP operations are well-understood. All-AMP retrieval typically involves full table scans, including NUSI sub-table scans. On the other hand, single-AMP retrieval typically involves indexed access, such as UPI and NUPI. Group-AMP operations optimize requests by minimizing the number of active AMPs. These operations fall between single-AMP and all-AMP operations. The Optimizer employs group-AMP …
Learn about Teradata Heuristics and Optimizer’s approach to estimating cardinality for non-indexed columns in this article. Discover how skew improves estimations and why heuristics should be avoided.
Learn about Teradata Statistics Extrapolation, a technique that allows for reasonable estimations when querying historical data with stale statistics.
Learn the truth about Teradata statistics and their impact on system performance. Address common misconceptions, follow best practices, and optimize your system for peak 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 the latest improvements in Teradata 14.00 that allow you to customize the collection of statistics to better suit your needs. These improvements include the option to set different sample sizes, consider more bytes for histogram creation, and choose the number of intervals for building statistics histograms. Read on to discover how these changes can benefit your optimization efforts.
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.
Learn about optimizing SQL queries in Teradata 14.10 by analyzing the execution plan of two queries and using statistics on columns and expressions.
Learn why it’s important to be careful when applying SQL functions on WHERE condition columns and how it can impact query performance.
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.