Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Query Optimizer » Query optimization and execution » Query execution algorithms

 

Table access methods

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

IndexScan method
IndexOnlyScan method (IO)
MultipleIndexScan method (MultIdx)
ParallelIndexScan method
TableScan method (seq)
ParallelTableScan method
HashTableScan method (HTS)
RowIdScan method (ROWID)

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0