In MySQL, the same query thrashes really hard. After some experimentation, it seems like the subquery itself is the problem. For instance: ...

The MySQL Heatwave Lakehouse changes that paradigm, enabling the database to query data that is stored in cloud object storage, commonly referred to as a data lake.