Partitioning
A collection of 21 issues
Designing Teradata Row Partitioning for Optimal Performance in Tactical Workloads
Teradata Columnar Solution: Advantages and Disadvantages
Switching from Teradata to Snowflake: What to Know About DML Statements and Data Deletion
Teradata Priority Scheduler and Resource Allocation Rules
Learn about Teradata's priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.
How to Join Partitioned Tables with an Unusual Trick for Improved Performance
Learn an unusual trick to improve the performance of joining partitioned tables with different primary indexes or partitioning. Read on to find out more.
Improve Performance with Teradata PPI Tables: Get a Grip on Clumpy Row Distribution
Get a Grip on Clumpy Row Distribution - the Teradata PPI Table.
For this technique to work properly, the primary index in Teradata should not include the partition column(s).
We have all encountered the issue of slow table inserts, where the distribution of rows across all AMPs is even,
An Introduction to Teradata Recursions: Generating Date Ranges Without a Physical Table
Introduction to Teradata Recursions
To link records from a primary table with a specific date range from a secondary table, a common requirement is to create a simulated history table with snapshot dates using a change history table with defined timelines. Consider the following illustration:
CREATE TABLE Snapshot_History(PK
How To Speed Up Your PPI Tables With A Secondary Index
Improving Performance through Query Rewriting with Row Partition Elimination: A Real-World Optimization Example on a 400-Million-Row Table
Learn how query rewriting can improve performance in row partition elimination. Follow the test setup to optimize the retrieval of rows from a table.