This message was deleted.

the join itself will be streamed, but the collection of subqueries A, B, C will not (they will be fully collected in memory before the join starts)