What is global vs local indexing in partitioned tables?

Local indexes are per-partition, while global indexes span all partitions.

Local indexes are maintained separately for each partition, making them easier to manage during partition operations. Global indexes cover entire table and are useful for queries spanning multiple partitions but are harder to maintain during partition changes.