Dynamic row partition elimination (DPE) is a form of partition elimination that occurs after data values in the tables are known to eliminate partitions: the database cannot determine the partitions to be eliminated until the plan is run and the data is scanned. Therefore, dynamic partition elimination must be applied on the AMPs after query optimization has already taken place.
Multiple forms of dynamic row partition elimination exist. For example, DPE for merge, hash, or product joins and DPE that occurs with a rowkey-based merge join. See Product Joins With Dynamic Row Partition Elimination and Product Join With Dynamic Row Partition Elimination for Character Partitioning for applications of dynamic row partition elimination.