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

Circumstances under which parallelism is used Next Page

Table access algorithms


This section explains the various methods used to access tables, with table and index scans being the most common methods.


Hash Table Scans
Index scans
Parallel index scans
Parallel table scans
ROWID Scan algorithm
Sequential table scans