Oracle Database 21c New Feature: Full Text Columns with In-Memory

 Oracle Database 21c New Feature: Full Text Columns with In-Memory.

This blog post by Andy Rivenes Product Manager at Oracle highlights this exciting new feature in 21c to the already expansive array of features boasted by Oracle Database In-Memory.

Here is a brief summary.

• In the previoius versions, Oracle Database In-Memory did not support predicates for non-scalar documents e.g. if you were using domain indexes for Oracle full text index, XML Search Index, or JSON Search Index then these were not populated in the IM column store. This resulted in degradataion of performance for searching non-scalar types of data. 
• Now in Oracle Database 21c In-Memory, there is new support  to store, or populate, these types of domain-specific indexes.
• The new 21c In-Memory Full Text Columns feature provides a faster way to perform searches on text type data.
• Full Text Columns do not require maintaining a separate Oracle Text index.
• Full Text Columns now support various types of application workloads within the Oracle converged database.

Enjoy this blog post announcing this exciting new capability now available for Oracle Database In-Memory.

Cheers.