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 » Table access algorithms

Parallel index scans Next Page

Parallel table scans

Parallel Table Scan operators work together under an exchange operator to do a sequential table scan in parallel. As each Parallel Table Scan operator requires rows, it takes the next unprocessed table page and returns rows from the page, one at a time. In this way, pages are divided between the operators to achieve parallel processing. Regardless of how the pages are distributed among the parallel table scan operators, all of the rows in the table are visited.