Duplicate elimination algorithms

A duplicate elimination operator produces an output that has no duplicate rows. Duplicate elimination nodes may be introduced by the optimizer, for example, when converting a nested query into a join.

For more information, see HashDistinct algorithm (DistH), and OrderedDistinct algorithm (DistO).


HashDistinct algorithm (DistH)
OrderedDistinct algorithm (DistO)