Oracle9i Index Partitioning Options
Similar to table partitioning, index partitioning is a method of intelligently breaking larger indexes into smaller pieces across many tablespaces. The two types of index partitioning are local and global. Local-partitioned indexes have the same partitioning key values, number of tablespaces, and partitioning rules as the underlying table, whereas global-partitioned indexes have a PARTITION BY RANGE or PARITION BY LIST clause that enables the partitioning values, number of partitions, and tablespaces themselves to all be defined and vary from the underlying table partitioning structure. These indexes can either be prefixed (meaning they contain a leading part of the index key) or nonprefixed (meaning they're ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
