There are several features in Oracle Database 12c Release 1 of which you can take advantage
when it comes to Data Warehousing and Business Intelligence (BI).

• You can use multipartition maintenance operations which enable adding multiple partitions to a table, dropping multiple partitions, merging multiple partitions into one partition, splitting of a single partition into multiple partitions, and truncating multiple partitions using a single SQL data definition language (DDL) statement.
• You can also recognize patterns in a sequence of rows by using the MATCH_RECOGNIZE clause in native SQL which executes efficiently.
• The new Synchronous Refresh feature will always keep a base table in sync with a Materialized View (MV) that is built on it.
• You can also improve query performance against OLAP cubes.
• Finally, local and global indexes can now be created on a subset of the partitions of a table. This feature provides more flexibility in index creation. Global index maintenance can now be delayed and decoupled using DROP and TRUNCATE partition without making a global index unusable. This new feature provides faster DROP and TRUNCATE partition operations. Index maintenance can be delayed to off-peak time.

Duration: 89 minutes

Release Date: 05-MAY-2014

Created by: Lauran Serhal