What’s the biggest problem with searching on a term that repeats many times in a database, such as searching for the last name “Smith” in a database of books?

A common term such as “Smith” appears in many records, so searching for it is likely to match a large number of books. The main problem is that the database returns too many results to be useful, not that it returns none or breaks its relationships.

AI-written and checked against the verified answer.