I have a nonpartitioned table in an application schema that has two
globally partitioned prefixed indexes. I do not know why the
original author decided to use partitioned indexes.
I've researched the Oracle docs and there is a description of local vs.
global indexes. But why would one choose to partition indexes on a
non-partiioend table?
Overall, global prefixed indexes are good for OLTP, support pruning, and
they are 'hard to manage'.
----------------------------------------
Thank you