Scanning every row without using an index.
Processing that scans every row of a table without using an index, which becomes a major performance drag as data volume grows. For a table with few rows, reading everything can actually be faster than the overhead of using an index, so the optimizer sometimes chooses a full scan on purpose -- a full scan by itself isn't automatically a problem.
© 2026 ITBGM