Deleting data from a heap table

When you delete rows from a heap table that does not have a useful index, Adaptive Server scans the data rows in the table to find the rows to delete. It cannot determine how many rows match the conditions in the query without examining every row.