Teradata Partial Redistribution and Partial Duplication (PRPD)

Dealing with data skew can be considered a principal activity in Teradata performance optimization. Although skew on table level usually can be avoided by choosing a proper Primary Index, skew arising during query execution is often a major issue (so-called spool skew). Spool skew is often emerging when joining tables (or spools).¬†On a typical Teradata … Continue reading Teradata Partial Redistribution and Partial Duplication (PRPD)