Add streaming index join support

Streaming index joins are activated as a last resort when index results cannot fit into the cache.
Move this down closer to where it is used