TABLE SCAN is a search strategy of the SQL optimizer.
The database system uses the sequential search in the following cases:
No search conditions have been specified.
Neither the key columns nor the indexed columns are included in the search condition.
The available non-sequential search strategies would be more costly than the sequential search.
The database system sequentially searches through the entire table.