Multi-stream: indexing the other side costs memory a sorted merge does not

The Map index that makes a join fast holds every row of one feed. When both feeds already arrive sorted, a merge answers the same question holding one row from each - the difference between a join that scales and one with a heap ceiling.

Full code & output

This topic is available to PRO members.