Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

New Index enhancement in Oracle 12c Part 1 – Multiple indexes on the same set of columns

New Index enhancement in Oracle 12c Part 1 – Multiple indexes on the same set of columns

 

In the article you will have a look at the following new index feature in oracle 12c ‘Multiple indexes on the same set of columns’. Staring with Oracle 12c you are enabled to create multiple indexes on the same set of columns. The following different indexes can be created on the same set of columns.

  1. Index of different type. Bitmap index and B-tree index.
  2. Partitioned index and not partitioned index.
  3. Locally partitioned index and globally partitioned index.
  4. Indexes differing in partitioning range and hash.
  5. Indexes that have different uniqueness properties. You can have both unique and non-unique index on the same set of columns.

Continue reading

November 1, 2016 Posted by | oracle | Leave a comment