Oracle Database - Leaf (block|Node) of a Btree index

Card Puncher Data Processing

Oracle Database - Leaf (block|Node) of a Btree index

About

The lowest level blocks in the tree of a Btree index, called leaf nodes or leaf blocks, contain every indexed key and a rowid that points to the row it is indexing.




Discover More
Card Puncher Data Processing
Oracle Database - Index Statistics

Statistics on Index stored in the data dictionary : DBA_INDEXES DBA_IND_STATISTICS Default Index Values When Statistics Are Missing Index Statistic Default Value Used by Optimizer Levels ...



Share this page:
Follow us:
Task Runner