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 » Query expression algorithms

Intersect algorithms Next Page

Recursive Table algorithm

A recursive table is a common table expression constructed as a result of a WITH clause in a query. The WITH clause is used for recursive union queries. Common table expressions are temporary views that are known only within the scope of a single SELECT statement.

For more information, see Common Table Expressions.