« How does it handle [multi-source] joins ? » is the obvious next question.

In memory, and if larger than memory it makes .duckdbtmp files to work from

So when you start doing crazy joins, a NVMe + big amount of RAM will really help DuckDB, in its work. Right?