Teradata Statistics Extrapolation: What it is and How it Works
Learn about Teradata Statistics Extrapolation, a technique that allows for reasonable estimations when querying historical data with stale statistics.
SQL
A collection of 180 issues
Simplify Teradata Development: Avoiding the Pitfalls of Over-Specialization and Large SQL Statements
Learn how specialization in Teradata development can lead to the development of huge SQL statements and how to reduce the risk of bad performance.
A Comprehensive Guide to Teradata Statistics: Common Misconceptions, Best Practices, and Real Reasons Behind Performance Degradation
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.
An Introduction to Teradata Recursions: Generating Date Ranges Without a Physical Table
Teradata Date Format and Time Values: Common Questions Answered
This article will address some common questions about formatting date and time values in Teradata. Teradata is a powerful relational database management system (RDBMS) that provides various functions to manipulate and manage date and time values. Understanding how to work with date and time data is essential for anyone using
How To Speed Up Your PPI Tables With A Secondary Index
Introduction to Teradata Nested Join: The Cheapest Join Method Using Indexes
Learn about the Teradata Nested Join, the cheapest join method using indexes. We explore its prerequisites, variants, and performance.
Understanding Teradata's SAMPLE Function: Randomly Select Rows and More
What is the Teradata Sample Function?
The SAMPLE function returns a set of randomly selected rows. Here are the characteristics:
* Ask for a sample with an absolute number of rows
* Ask for a sample that contains a certain percentage of the table rows
* Ask for more than one sample at
Improving Row Estimates with Teradata Check Constraints
Teradata Row Size Limits: Understanding and Overcoming the 3577 Error
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.