What does an execution plan’s ‘Table Scan’ or ‘Seq Scan’ operator indicate?

Question

SQL Fundamentals — Hard

What does an execution plan’s ‘Table Scan’ or ‘Seq Scan’ operator indicate?

Accepted Answer

The 'Table Scan' or 'Seq Scan' operator in an execution plan indicates that every row in the table is being read sequentially without using an index. This means that the database is scanning the entire table row by row to retrieve the necessary data.