Full table scan
Data & DatabasesReading every row to answer one question.
What the database resorts to when no index supports your query. Instant with ten rows, catastrophic with ten million, which is why this problem never appears during development.