How to solve: Filter Big Countries by Area and Population?

Question

Accepted Answer

This query evaluates standard boolean predicate filtering using `OR`. When optimizing on large tables with individual column indexes on `area` and `population`, using `UNION` allows the engine to utilize index seeks on both columns independently.