jump to navigation

Oracle Database 18c Indexing Related New Features (New Angels of Promise) February 27, 2018

Posted by Richard Foote in Oracle Indexes.
2 comments

new angels of promise

Although the recently released Oracle 18c Database is really just 12.2.0.2 under the covers, there are a few little features and enhancements that are of interest from an indexing perspective. These include:

  • Memory Optimized Rowstore
  • Scalable Sequences
  • Oracle Text indexing enhancements, such as automatic background index maintenance and new optimize index options
  • JSON Search Index key name limit increased from 64 to 255 characters
  • Spatial Index support with Oracle Database Sharding
  • Golden Gate automatic conflict detect and resolution (CDR) support on tables with just Unique Constraints and/or Unique Indexes (previously required a Primary Key)
  • Modifying the partitioning strategy using a single, online DML, which can be extremely useful with regard modifying related indexing strategies
  • Online Merging of partitions and subpartitions (and impact on associated indexes)

 

The complete list of all that’s new with the Oracle 18c Database, check out the online manuals.

If you don’t have an Oracle Cloud account or an Oracle Engineered System to play around with the 18c database, you can have a play on Oracle Live SQL.

I’ll be blogging about these new features and enhancements (and various others) in the coming weeks so keep and eye out.

Advertisements