Teradata Statistics Collection for Improved Query Performance
Learn how to optimize your Teradata queries with statistics collection. Discover what to collect and what to omit for accurate query estimation.
Indexing
A collection of 141 issues
VantageCloud Lake: Turbocharge Your Data Warehousing with Teradata's Innovative Solution
Introduction
Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures.
Teradata is a powerful and scalable relational
Improving Query Performance with Teradata Statistics Extrapolation and Object Use Counts (OUC)
Optimizing Teradata Queries: From No Index to Hashed NUSI
The initial situation without any index
In this blog, I will demonstrate how to optimize a query using Teradata's tools.
We will begin with the following test scenario:
CREATE TABLE Orders
(
OrderId BIGINT NOT NULL,
CustomerId BIGINT NOT NULL,
Amount BIGINT
) PRIMARY INDEX (OrderId);
INSERT INTO Orders
SELECT
Understanding Teradata Hash Collisions - A Case Study
To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand:
https://letters.dwhpro.com/content/files/2026/05/teradata-physical-storage.html
As you know, a hashing algorithm
The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance
Why is Teradata I/O so crucial?
Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data.
Transferring data to the main memory is significantly slower than accessing data in the main
Teradata Columnar Solution: Advantages and Disadvantages
How Advanced Is The Teradata Columnar Solution?
A Column Store is defined by three distinct properties:
* Improved compression compared to Row Stores.
This results from considerably better compression rates that we can achieve by packing columns into data blocks. Since the values of a column come from a domain, the
Understanding Teradata's Primary AMP Index for Improved Performance
Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index.
This blog post will demonstrate a Primary AMP Index's benefits and optimal usage for improving load and query performance.
First,
Zero-Copy Clones: A Space and Time-Saving Solution for Database Management with Snowflake
Teradata in the Cloud: Advantages and Disadvantages of MPP Database Systems
Introduction to Teradata in the Cloud
Cloud databases are pressuring traditional data warehousing MPP systems.
This blog post will illustrate the reasons for this and outline the pros and cons of each database system.
The Architecture of an MPP Database System
MPP database systems employ a shared-nothing architecture, wherein each