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
The importance of the PDM
Compression is a widely used method for reducing IOs by enabling the accommodation of more rows in each data block. Data blocks are the smallest unit exchanged between hard drives and main memory, which is the most costly operation in any database system.
Compression can
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.