When ParallelTableScan is used, individual TableScan operators work together under an Exchange operator to do a sequential table scan in parallel. As each TableScan 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 TableScan operators to achieve parallel processing. Regardless of how the pages are distributed among the parallel TableScan operators, all of the rows in the table are visited.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |