This article brings together all the articles related to index enhancements in Oracle Database 12c Release 1. - Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition - Partial Index for Partitioned Tables - Multiple Indexes on the Same Set of Columns - Indexing JSON Data - Online Operation Enhancements - Advanced Index Compression Hope this helps. Regards Tim...