Presto |best| Full -

-- Rows only in A WHERE b.join_key IS NULL -- Rows only in B WHERE a.join_key IS NULL

Presto compiles queries into bytecode and executes them directly, avoiding the overhead of launching new processes for every query. The engine is written in Java but is heavily optimized for memory management and CPU efficiency. presto full