Sign in Subscribe

Statistics

A collection of 51 issues

How to Use Biased Value Histograms for Accurate Statistics Estimation on Teradata SQL

Learn how biased value histograms store exact cardinalities and provide up-to-date statistics for queries, and witness how the Optimizer estimates the number of rows for a given query.

Practical Approach for Teradata SQL Tuning: Finding the Root Cause of Performance Issues

To optimize Teradata SQL performance, it is crucial to identify the root cause of any issues. The SQL statement itself is typically not the culprit but rather one or more stages of the execution plan. This article does not cover genuine optimization techniques. Instead, it presents a pragmatic method for

Improvements in Tailoring Statistics Collection with Teradata 14.00: Using Sample, MaxValueLength, and MaxIntervals Options

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 s

Analyzing and Fixing Teradata Statistics Estimation Problem

Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.

Teradata SQL Performance: IN vs BETWEEN and the Use of Statistics on Columns

Learn about optimizing SQL queries in Teradata 14.10 by analyzing the execution plan of two queries and using statistics on columns and expressions.

The Importance of Avoiding SQL Functions on WHERE Condition Columns for Optimizer Performance

Learn why it's important to be careful when applying SQL functions on WHERE condition columns and how it can impact query performance.

Boosting Teradata Statistics Performance with New Syntax in Release 14.00

Discover the improvements for Teradata statistics with the new syntax starting from Release 14.00. Learn how to optimize performance and usage.

Understanding MaxValueLength and Its Importance in Teradata Statistics

Learn about Teradata's MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.

Teradata Statistics Maintenance: Milestones, Aging and Recollection, Collection Statement Register, and Triggered Partial Recollection Specification

Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.

Optimizing Workload with Teradata's Sample Statistics Feature

Learn how to gather statistical samples in Teradata systems to reduce workload and generate comparable execution plans through sample statistics.