What is a full table scan and why is it expensive?

A full table scan reads every row in a table sequentially.

Full table scans occur when no suitable index exists or the optimizer decides scanning is cheaper. It is expensive because it increases disk I/O, CPU usage, and memory consumption. It becomes particularly problematic in large-scale datasets.