ASA SQL User's Guide Query Optimization and Execution Query execution algorithms
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