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)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |