Question: what is the difference between local and global index?
Answer: Global Index: A global index is a one-to-many relationship, allowing one index partition to map to many table partitions. ... Local Index: A local index is a one-to-one mapping between a index partition and a table partition.