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)