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.
Query Optimization
A collection of 72 issues
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.
Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload
Learn how Teradata applies two effective join optimization methods, Early and Partial GROUP BY, for decision support workloads with lots of aggregations. These transformations reduce resource usage and are widely used in modern databases. Discover how to improve the optimizer's chance to apply these
Teradata Partitioning: Row vs. Column for Efficient Data Access
Learn about Teradata Partitioning and how row and column partitioning can minimize data access resource usage. Read on for benefits and examples.
How to Avoid Full Table Scans When Using LIKE Operators in Teradata Indexing
Learn how to avoid resource-killing full table scans on extensive tables with Teradata Indexing. Discover a fantastic trick to optimize 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.
The Teradata RDBMS
The Vulnerability of Outer Joins in Business Intelligence Tools: A Simple Test Scenario
Learn why business intelligence tools often use outer joins and why they can be vulnerable to skewing. Read on to understand the details and risks involved.
Teradata Comparison Operators and Performance: Why Choosing the Right Operator Matters
Learn how Teradata Comparison Operators and Performance are linked, and how choosing the right operator can impact query performance. Column statistics play a crucial role in the Teradata Optimizer, and this article explores how to use them effectively.
Unlock the Power of Distributed Queries with Teradata Querygrid: Benefits and How-to Guide
Teradata Querygrid is a Teradata database management system component that enables users to retrieve data from various sources and conduct distributed queries. This article examines the Teradata Querygrid concept, its advantages, and its application in accessing and querying data from heterogeneous sources.
What is Teradata Querygrid?
Teradata Querygrid is a