Contents Index Query execution algorithms Index scans

ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms

Accessing tables


The basic ways to access single tables are the index scan and the sequential table scan.


Index scans
Sequential table scans
IN list
Recursive table

Contents Index Query execution algorithms Index scans