Partitioning
A collection of 21 issues
Designing Teradata Row Partitioning for Optimal Performance in Tactical Workloads
Teradata Columnar Solution: Advantages and Disadvantages
How Advanced Is The Teradata Columnar Solution?
A Column Store is defined by three distinct properties:
* Improved compression compared to Row Stores.
This results from considerably better compression rates that we can achieve by packing columns into data blocks. Since the values of a column come from a domain, the
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
An Introduction to Teradata Recursions: Generating Date Ranges Without a Physical Table
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.