The in-memory join option builds a hash table from one input for faster lookup, not for maintaining sort order. Hash-based joins provide O(1) lookup but don't preserve sorted output. If you need sorted output, you must explicitly add a Sort component after the join.