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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Query optimization and execution » Query execution algorithms » Types of algorithms


Query expression algorithms

The query expression algorithms can be broken into the following categories:

  • Except algorithms, which include MergeExcept and HashExcept

  • Intersect algorithms, which include MergeIntersect and HashIntersect

  • Union algorithms, which include Union, UnionAll, and RecursiveUnion

Except algorithms (EAH, EAM, EH, EM)
Intersect algorithms (IH, IM, IAH, IAM)
RecursiveTable algorithm (RT)
RecursiveUnion algorithm (RU)
RowReplicate algorithm (RR)
UnionAll algorithm (UA)