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.
Indexing
A collection of 141 issues
Decomposable Columns: Definition, Impact on Performance, and Workarounds
Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.
Improving Teradata Performance with SQL Query Rewriting
Learn how to improve the performance of SQL statements by rewriting them through this article on Teradata tuning. Follow along as we analyze a high-runtime SQL statement and optimize it to significantly reduce disk I/O and spool space usage.
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.
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.
Improve Performance with Teradata Partition Elimination: The Stored Procedure Approach
Learn how to solve the problem of accessing a table containing many rows using Teradata Partition Elimination with a Stored Procedure.
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.
Optimal Performance by Avoiding CHARACTER Columns in the Primary Index
The Teradata Primary Index and Hash Collisions
Using either INTEGER or CHARACTER data types for the Teradata Primary Index does not usually impact performance. The hashing algorithm in Teradata is highly efficient. In the rare case where primary index columns from different tables have different CHARACTER SET, there may be
Teradata Statistics Maintenance: Milestones, Aging and Recollection, Collection Statement Register, and Triggered Partial Recollection Specification
Learn how to maintain your Teradata data warehouse to keep it running smoothly. Discover how to collect statistics and refresh them as needed.