16.10 - Dynamic Row Partition Elimination - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

Dynamic row partition elimination (DPE) is a form of partition elimination that cannot occur until data values in the tables are known in order to eliminate partitions: Teradata Database cannot determine the partitions to be eliminated until the plan is executed and the data is scanned. Because of this, dynamic partition elimination must be applied on the AMPs after query optimization has already taken place.

Several forms of dynamic row partition elimination exist such as DPE for merge or product join, DPE that occurs with a rowkey-based merge join, and others. See Product Joins With Dynamic Row Partition Elimination and Product Join With Dynamic Row Partition Elimination for Character Partitioningfor some applications of dynamic row partition elimination.