New Oracle Text Index Type: Search Index

The search indexes for text columns support support sharding and all partition types. Index creation syntax is also simpler now.

The search index type maintains most of the features of the traditional CONTEXT index type, but has support for sharding and for multiple partitioning methods (the previous CONTEXT index type can only support range partitioning). It also has a simplified index creation syntax avoiding the semantic complexity necessary for CONTEXT indexes.

Related Topics