Contents Index Recursive left outer hash join Hash distinct

ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms

Duplicate elimination


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 Hash distinct, Ordered distinct, and Indexed distinct.


Hash distinct
Ordered distinct
Indexed distinct

Contents Index Recursive left outer hash join Hash distinct