Btree : Balanced tree index

Let’s draw a table (any table). For simplicity I say: a block can only cater for 4 rows The table has 2 columns (ID and Text) Oracle assigns a rownumber within the block for every row If I would like to see all rows where ID=154, Oracle would have to look in all blocks, and […]

Continue Reading