23c Deep Dive – In-Memory Vector Join Enhancements

In Oracle Database 23c In-Memory Deep Vectorization has been expanded to support the following additional join types: Multi-level hash joins, Multi join key, Semi joins, Outer joins, Full group by aggregation. This enhancement enables additional performance by leveraging Single Instruction Multiple Data (SIMD) vector instructions.