Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Query Optimization and Execution » Query execution algorithms

Recursive Left Outer Hash Join algorithm Next Page

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 Hash Distinct algorithm, and Ordered Distinct algorithm.

Hash Distinct algorithm
Ordered Distinct algorithm