组合索引leaf 数据存储

1 Z
2 X
3 U
4 T
5 G
6 F
7 C
8 B
9 A
1 A
2 B
3 C
4 D
Oracle的索引是以平衡树的方式组织存储的:保存的是索引列的值,以及该行的rowid的一部分(文件号,块号,行号) 
下面我们通过例子来了解一下:


1,create table test(id int,name varchar2(20))
insert into test values(1,'Z');
insert into test values(2,'X');
insert into test values(3,'U');
insert into test values(4,'T');

insert into test values(5,'G');
insert into test values(6,'F');

insert into test values(7,'C');
insert into test values(8,'B');
insert into test values(9,'A');

insert into test values(1,'Z');
insert into test values(2,'B');
insert into test values(3,'C');

insert into test values(4,'D');
insert into test values(5,'F');

insert into test values(6,'H');
insert into test values(7,'G');

insert into test values(8,'H');
insert into test values(8,'I');

beg