index rang scan

根:分支的范围,范围块的地址

----- begin tree dump
branch: 0x1000c93 16780435 (0: nrow: 5, level: 1)
   leaf: 0x1000c94 16780436 (-1: nrow: 485 rrow: 485)
   leaf: 0x1000c95 16780437 (0: nrow: 479 rrow: 479)
   leaf: 0x1000c96 16780438 (1: nrow: 479 rrow: 479)
   leaf: 0x1000c97 16780439 (2: nrow: 479 rrow: 479)
   leaf: 0x1000c98 16780440 (3: nrow: 78 rrow: 78)
----- end tree dump

SQL> select dbms_utility.data_block_address_file('16780435') FILE_ID,
       dbms_utility.data_block_address_block('16780435') BLOCK_ID
  from dual;  2    3 

   FILE_ID   BLOCK_ID
---------- ----------
  4  3219

Btree 索引的 root block总是segment header+1,所以我查询该索引的段头 
 
SQ