INMEMORY_DEEP_VECTORIZATION

INMEMORY_DEEP_VECTORIZATION enables or disables the deep vectorization framework.

Property	Description
Parameter type	Boolean
Default value	TRUE
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Range of values	TRUE | FALSE
Basic	No

Deep vectorization can optimize complex SQL operations (such as joins) by pipelining physical operators inside each SQL operator and vectorizing them.

See Also: Oracle AI Database In-Memory Guide for information about deep vectorization