In-Memory Full Text Columns

Oracle Text technology supports an INMEMORY TEXT directive during table creation, enabling fast in-memory searching using a CONTAINS clause.

An in-memory table scan can now evaluate non-scalar data. When the In-Memory Column Store contains both scalar and non-scalar columns, On-line Transaction Processing (OLTP) applications that access both types of data can avoid accessing the row store, thereby improving performance.

Related Topics