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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Query Optimizer » Query optimization and execution » Query execution 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)