I/O cost of table accesses based on index range scans
-
Access the root block of the index.
- Go through the branch blocks to locate the leaf block containing the first keys.
- For each key fulfilling the search criteria, do the following:
Extract the rowid referencing the data block.
Access the data block referenced by the rowid.