Add/Drop Partitions

[jhmartin]

Does your question mean all the global indexing can be substituted
by local indexing?

Local indexes must contain the partition key, and it is ideal if the leading column of the index IS the partition key. If you can't do that then local indexes won't work.