Two types of indexes support locating data within a partitioned table, as follows:

  • Global

    A Global index on a partitioned table spans all partitions. There is one index b-tree for all of the data, and provides uniqueness for non-partitioned columns.

  • Partition-aligned local

    A partition-aligned local index has one index b-tree for each partition.

    Note: Word indexes can not be local indexes.