Teradata PPI: Understanding Partitioned Primary Index for Improved Performance
Learn about the benefits of partitioned primary index (PPI) in Teradata, a method for reducing I/Os and improving performance in database systems.
Partitioning
A collection of 21 issues
Improving Query Optimization with Teradata IPE
Learn about Teradata IPE, a technique that uses additional information collected during query execution to create execution plans in fragments.
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.
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.
Teradata OLAP Functions: A Systematic Approach to Understanding Window Aggregates
Learn how to work with Teradata OLAP Functions in your data warehouse applications. This systematic approach covers five key design decisions.
Efficiently Adding New Partitions to a Row Partitioned Teradata Table: A Comparison of Alter Table vs Insert Select
Learn how to efficiently add new partitions to a Row Partitioned Table. We compare two methods, ALTER TABLE and INSERT…SELECT, with test results.
Maximizing Performance with Teradata Partitioning Strategies
Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.
Teradata Primary and Secondary Index: Understanding the Differences and Importance for Performance Tuning
Learn about the Teradata Primary Index and how it differs from a primary key. Discover the benefits of defining a primary index and how many can be created per table.
Maximizing Efficiency: Teradata vs. Snowflake Partitioning
Learn how Teradata and Snowflake minimize IOs to enhance performance. Teradata uses row partitioning while Snowflake relies on micro-partitions.