What is Block Level Compression (BLC) and How Does it Work for Teradata?
Block Level Compression (BLC) is a feature that allows compression of entire data blocks, leading to disk space reduction. Read on to know more.
Architecture
A collection of 111 issues
Teradata Hash Index: Minimizing Disk IOs and Optimizing Row Access
Learn about the Teradata Hash Index, designed to minimize disk IOs and improve access to rows. Discover how it differs from Single Table Join Indexes.
Teradata SQL Tuning: Minimizing Costs and Maximizing Parallelism
Learn how to optimize SQL tuning on Teradata by minimizing I/Os and maximizing parallelism, which can be achieved by evenly distributing rows across all AMPs.
The Importance of PDM in Database Compression and Resource Usage Optimization
Improve Query Performance by Using the Teradata CLOB Datatype for Storing Longer Texts
Learn how the Teradata CLOB datatype can improve query performance and reduce resource consumption for storing longer texts in your database.
Understanding Teradata Value Ordering for Improved Range Scans and Data Retrieval
Learn about Teradata value ordering, an optimization technique for range scans of 32-bit integers. Read on to understand how it is implemented.
Understanding Teradata Nodes in Parallel Systems: Architecture and Scalability
Learn about Teradata Nodes - Linux systems packed into cabinets with multicore CPUs, memory, and parallel database extension software (PDE).
Teradata DATABLOCKSIZE: How to Minimize Disk I/Os and Optimize Workload Requirements
Learn how to minimize disk IOs with the Teradata DatablockSize option. Read on for an overview of how it works and how to choose the best size.
Understanding the Teradata Primary Index: Distribution, Hashing Algorithm, and Performance Considerations
Learn about the Teradata Primary Index, which distributes table rows across all AMPs for parallel execution. Discover how to select the best index for performance and avoid hash collisions.
The Teradata RDBMS
Introduction
Teradata is a name synonymous with data warehousing and large-scale data analytics. Teradata has provided organizations with innovative solutions and technologies for over four decades as a pioneer in the field. This article will delve into the fascinating world of Teradata, exploring its history, architecture, and diverse applications. We