‘Hidden’ Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part III” (Ricochet)

(Richard Foote) In Part I and Part II of this series, we looked at how Global Indexes can effectively perform “Partition Pruning” when the partition keys are specified in SQL predicates, by only using those index entries that have a Data Object of interest stored within the index Rowids.

Register to Read