Select operations on heap tables

When you issue a select query on a heap, and there is no useful index, Adaptive Server must scan every data page in the table to find every row that satisfies the conditions in the query. There may be one row, many rows, or no rows that match.