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

Ordered Distinct algorithm Next Page

Grouping algorithms

Grouping algorithms compute a summary of their input. They are applicable only if the query contains a GROUP BY clause, or if the query contains aggregate functions (such as SELECT COUNT(*) FROM T).

For more information, see Hash Group By algorithm, Ordered Group By algorithm, and Single Group By algorithm.

Clustered Hash Group By algorithm
Hash Group By algorithm
Hash Group By Sets algorithm
Ordered Group By algorithm
Ordered Group By Sets algorithm
Single Group By algorithm
Single XML Group By algorithm
Sorted Group By Sets algorithm