The Table Scan icon indicates that all rows in the table were paged in and selection criteria were applied against each row. Only those rows meeting the selection criteria were retrieved. To get the result in a particular sequence, you must specify the ORDER BY clause.
Also referred to as Table Scan, Preload.
See Tips for table scan for more details.