How does an index range scan happen? I want to know how Oracle works
under the hood when it does an index range scan. Say the range scan is
from 10-20. Does Oracle get to the first index leaf node (10), get the
rowid and then go to the table, grab that row and then come back to
the index and read the next index leaf node (11) and repeat the
process? OR Does Oracle read all the row IDs from all relevant leaf
nodes and only then go to the table?
many thanks
Received on Sat Mar 27 2004 - 03:35:09 CST
