From the course: Oracle 12c: New Features

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Partial indexes

Partial indexes - Oracle Database Tutorial

From the course: Oracle 12c: New Features

Start my 1-month free trial

Partial indexes

- [Instructor] Oracle 12c introduces a new feature called Partial Indexes which enables the creation of indexes on specific table partitions only. This is useful because indexes can consume a lot of space especially for large tables and we always want to be as efficient as possible. What if you have a partition table and only some of the table partitions are relevant from a high performance query perspective? Let's say some of these partitions store historical data which is not very performance sensitive. But other partitions store more recent data which are very performance critical. With previous Oracle versions for optimal performance you often had to create an index on the partition table covering all partitions. Wasting space for the partitions where you didn't really need the index. With Oracle 12c and partial indexes it's a different story and we can actually create indexes for specific table partitions only. It's very easy to create these partial indexes all we have to do is…

Contents