Dynamic Row Partition Elimination | Optimizer Process | Teradata Vantage - Dynamic Row Partition Elimination - Advanced SQL Engine - Teradata Database

SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
ykx1561500561173.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1142
lifecycle
previous
Product Category
Teradata Vantageā„¢

Dynamic row partition elimination (DPE) is a form of partition elimination that occurs after data values in the tables are known in order to eliminate partitions: the 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, hash, or product joins, 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 Partitioning for some applications of dynamic row partition elimination.