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 - Oracle Database Tutorial
From the course: Oracle 12c: New Features
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.