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.
Discover the importance of Teradata statistics in optimizing query execution plans. Learn how to collect statistics and when to use them for best results.
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 why it’s important to be careful when applying SQL functions on WHERE condition columns and how it can impact query performance.
Discover the improvements for Teradata statistics with the new syntax starting from Release 14.00. Learn how to optimize performance and usage.
Learn about Teradata’s MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.
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.