‘Hidden’ Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part II (Aladdin Sane)

(Richard Foote) In Part I of this series, I highlighted how a Non-Partitioned Global Index on a Partitioned Table is able to effectively perform “Partition Pruning” by reading only the associated index entries to access just the table blocks of interest from relevant table partitions when the table

Register to Read