May 08, 2019  Hidden Efficiencies of NonPartitioned Indexes on Partitioned Tables Part IV (Hallo Spaceboy) October 31, 2018 Posted by Richard Foote in Global Indexes, Local Indexes, Oracle Indexes, Partitioned Indexes. 3 comments. In Part I, Part II and Part III we looked at some advantages of Global Indexes that may not be obvious to some. . One of the advantages of a Local Index vs. Non