Partitioned and nonpartitioned indexes

Partitioned data can have:

• indexes that are nonpartitioned, existing in a single table space within a database partition.
• indexes that are themselves partitioned across one or more table spaces within a database partition.
• a combination of partitioned and nonpartitioned indexes.

Partitioned indexes are beneficial when you run roll-in operations with partitioned tables. That is, attaching a data partition to another table with the ATTACH PARTITION clause on the ALTER table statement.