>Most modern RDBMS are optimized for point-lookup queries and have a very hard time choosing good plans when you're selecting millions of rows amongst billions.

>Most modern RDBMS are optimized for point-lookup queries and have a very hard time choosing good plans when you're selecting millions of rows amongst billions. Any column store warehouse (Redshift, Bigquery, Snowflake) is terrific for these kinds of queries, though.