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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Query Processing » 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)